What’s New in the Postgres 16 Query Planner / Optimizer — Query planner improvements rarely make the headlines when a new release of Postgres lands, but Postgres 16 gained some significant improvements that are enhancing all of our queries today. David walks through ten recent optimizations, complete with Postgres 15 vs 16 query plans, and shows us how and when things have improved.

David Rowley

Auto Optimize Your RDS or Aurora Postgres Databases With AI — Need help optimizing Postgres knobs, queries, indexes and autovacuum? OtterTune is your AI-powered database co-pilot that can improve performance, reduce costs and keep your databases healthy. Get a free, 30-day trial for three databases.

OtterTune sponsor

PostgreSQL 16.2, 15.6, 14.11, 13.14, and 12.18 Released — All supported versions get updates to fix a variety of bugs, as well as a security vulnerability where the owner of a materialized view could get a higher privileged user to run code associated with that view at their higher level (now all user-determined code is run as the view’s owner, as it’s meant to be).

PostgreSQL Global Development Group

pg_analytics: Transforming Postgres into a Fast OLAP Database — Some interesting work from the folks over at ParadeDB. pg_analytics is an extension that significantly accelerates analytical query processing in Postgres, all without having to adopt an OLAP database.

ParadeDB

Connecting to Postgres with psql and .pg_service.conf — Forgot how to connect to your Postgres services? Say goodbye to psql -h and hello to .pg_service.conf, Postgres’s connection service file.

James Blackwood-Sewell (Timescale)

(Plausible) Random Geography Generation with PostGIS: Fluviation — Geospatial stuff tends to go over my head, but I love seeing it. Great post with visuals.

Dian M Fay

pg_graphql 1.5: Bring GraphQL Support to Postgres — Reflects a GraphQL schema from the existing SQL schema, letting any GraphQL client query the database via GraphQL with no additional servers, processes, or libraries. v1.5 adds support for offset pagination via first and offset.

Supabase

pgmeminfo: A New Extension to Investigate Memory Usage — Pavel shows off his new extension which provides extended access to memory usage statistics from within Postgres, including info about Postgres is internally managing memory.

Pavel Stěhule

pgagroal-cli Gains JSON Output Support — pgagroal is a high performance connection pool for Postgres and it now supports JSON output, which can be handy for automation scenarios and other integrations.

Luca Ferrari