What if Postgres didn’t need VACUUM at all? This seems hard to imagine, but some folks at EnterpriseDB are investigating the possibility.

Explanation, links, and examples of B-trees, hashes, GIN, GiST, SP-GiST, BRIN, RUM, Bloom filter, bitmap and other types.

Using table partitioning to support an idea akin to ‘rotating’ log files, but with logs stored in Postgres.

Collect out-of-the-box and custom Postgres metrics and correlate them with data from across your distributed infrastructure and applications. Gain real-time performance insights and set intelligent alerts with Datadog. Try it free.

An accessible introduction to B-tree indexes and how they work.

A very brief overview: “PostgreSQL 11 is looking like we’ll be able to add referential integrity to partitioned tables.”

The Citus 7.2 extension to Postgres now includes distributed database features such as expanded support for distributed SQL and the distribution of complex subqueries across multiple nodes, and more.

Taking place on Lake Garda, Italy, on June 29th.

pg_partman is a ‘best in class’ extension for improving time-based partitioning on Postgres and here’s how to use it with a Citus cluster.

It’s possible to write stored procedures in almost any language. When it comes to slow procedures Postgres often isn’t to blame, and here’s why.