B-Tree Index Improvements in Postgres 12 — B-tree indexes have been improved in Postgres v12 - this article describes some easily understood examples. It won’t affect most users but there are some performance benefits, particularly for databases stored on media with poor random read performance (e.g. magnetic storage).

Laurenz Albe

12 Common Mistakes and Missed Optimization Opportunities in SQL — A lengthy list of SQL “dos and don’ts” covering topics like timezones, ranges, formatting queries, and unions.

Haki Benita

Multitenancy Options in Postgres — A high-level overview of the Postgres architecture helps provide some contextual understanding of the multitenancy options available with Postgres. Download this white paper to learn more about the three main Postgres multitenancy options.

EnterpriseDB sponsor

How To Get Started with pgBackRest on Postgres 12 — pgBackRest is a backup and restore tool for Postgres that now takes advantages of some of the new features in Postgres 12. Here’s how to set up and configure it.

Tom Swartz

Deploying and Configuring Postgres with Puppet — Runs through the installation and programming of Puppet modules (Puppet being a popular open source config management and deployment system) for deploying/configuring your databases.

Hugo Dias

Converting from Asynchronous to Synchronous Replication in PostgreSQL — Shows you how to install a PostgreSQL Cluster from scratch and convert the asynchronous replication (default) to a synchronous one.

Sebastian Insausti

An Overview of VACUUM Processing in Postgres

Kumar Rajeev Rastogi

Sum Types for Relational Databases — A look at different ways to encode sum types.

Dmitry Olshansky

Waiting for PostgreSQL 13: Allow Invisible PROMPT2 in psql — This is a really minor thing in the grand scheme of things but psql in Postgres 13 will make prompts a little nicer when entering multi-line queries.

Hubert depesz Lubaczewski

PGLoader: A Data Loading Tool for Migrating to Postgres — A COPY-based data loading tool that supports both parallelism and can load in data that may be partially erroneous but without stopping (as \copy might).

Dimitri Fontaine

eBook: Best Practices for Optimizing Postgres Query Performance — Learn how to get a 3x performance improvement on your Postgres database and 500x reduced data loaded from disk in this free pganalyze eBook.

pganalyze sponsor

pg_simdjson: An Extension for Parsing JSON using simdjson — This is a prototype/experiment for now but I like seeing things like this out there. This extension uses the high performance simdjson parser to (slightly, so far) outperform Postgres’s native JSON parser.

Dmitry Dolgov

pg_query_state: A Module for Query Progress Monitoring

Postgres Professional