~postgresweekly | Issue 542 - PG 16's query planning enhancements (8)

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.

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.

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).

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.

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.

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

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.

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.