If you're getting started with learning about indexes, here are a few things that hopefully will help round out your understanding.
In this post, we'll take a quick look at how to get started with using PL/Python to write Postgres functions.
When the keyword LATERAL is added to your join the output will now apply the right hand part of the join to every record in the left part of the join.
A BRIN is a Block Range Index. A block is Postgres’ base unit of storage and is by default 8kB of data.
In my first post, I talk about how Django's built-in authentication system can do some of the heavy lifting for your registration setup. In this post, I'll walk you through how we tied our data models and authentication together by extending Django's User model.
Learn how to add a user registration system using Django's built in authentication.
This post is a refresher on INSERT and also introduces the RETURNING and ON CONFLICT clauses if you haven't used them yet, commonly known as upsert.
Learn how to use composite primary keys in a PostgreSQL many-to-many relationship table while building a Django application.
An overview of composite types within Postgres and when to use them.
In Postgres, we have several data types that may not be as well known even for experienced developers. Take a quick look at arrays, enum, and range types.
Kat Batuigas dives into some interesting aspects of PostgreSQL base data types.
Learn how to document all of the tables in your PostgreSQL database without having to type all the commands that needed.
A PostgreSQL block range index, or BRIN, can help you to significantly reduce the amount of disk space required for high performance queries on big data.
WITH queries, aka common table expressions, aka CTEs, are a very powerful but often misused feature in PostgreSQL. The upcoming PostgreSQL 12 introduces the ability to inline WITH queries with can provide a huge performance optimization to how developers use CTEs.
Covering indexes in PostgreSQL are an incredibly helpful feature that can help improve the performance of your application when used correctly. This article demonstrates how an application that collects time-series and geospatial data is able to use covering indexes to boost performance.
COPY is also incredibly helpful for ingesting data such as JSON or CSV into a PostgreSQL table, especially if there is a lot of it. Learn how to use COPY to optimize your data loading performance in PostgreSQL.
This article provides an easy recipe for creating a PostgreSQL primary-replica cluster using Docker Swarm.
Easy setup and installation for PostgreSQL 10 and pgAdmin 4 with Docker and open source containers packaged by Crunchy Data.
An overview of how to set up and run PostgreSQL in docker containers using docker 1.12.