Shaun Thomas

Have you ever executed a query and wondered: how much RAM will that use? The documentation explains that each query node can allocate a copy of work_mem , but there’s no way to know how much that will be before or even after a query runs aside from literally counting the nodes by hand following an EXPLAIN .

The release announcement for Postgres 16 included this cryptic note: Finally, this release begins adding support for bidirectional logical replication, introducing functionality to replicate data between two tables from different publishers.

Postgres major version upgrades are a lot of work! Before you start reaching for that handy pg_upgrade utility and accepting the inevitable downtime as part of the equation, let us describe a Better Way™.

AI is a hot topic right now, and for good reason! Natural Language Search and Retrieval Augmented Generation (RAG) are two great ways to leverage data stored in Postgres in an immediately useful way.

Do you know what ETL is, and hate it with a fiery passion? Maybe you're sick of exporting to various reporting systems, just so Frank from Accounting can complain about everything being slow.