#​542 — February 14, 2024

Web Version

📅 If you're looking for a Postgres event to attend, check out the list at the end of this issue. So many have popped up on my radar recently, I wanted to share as many as I could. If you know of any others, drop me a line!
Your editor, Peter Cooper

Together with  Ottertune logo

Postgres Weekly

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

🗣 This post provoked extensive discussion on Hacker News.

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.



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)

📰 Classifieds

📢 Free pgEdge distributed Postgres DB with 3 node active-active cluster and one-click provisioning across 3 regions. Free t-shirt to first 500.

'Perfect resolution, excellent audio, no lag'. Try Tuple for free today, no credit card required.

(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

UUID Benchmark War: Benchmarking UUID Approaches
Jeremy Schneider

Understanding RDS Pricing
Mencarelli, Soto and Tavares (Timescale)

🛠 Code and Tools

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.


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 Supportpgagroal 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

  • TimescaleDB 2.14.0 – Time series capabilities for Postgres in an extension. This version lets you change the compression settings on existing compressed hypertables at any time.

  • PostGIS patch releases: v3.4.2, 3.3.6, 3.2.7, 3.1.11, 3.0.11, and 2.5.10.