Databases: PostgreSQL Releases, Analyses, and More

posted by Roy Schestowitz on Apr 30, 2025

• Shayon Mukherjee ☛ A PostgreSQL planner gotcha with CTEs DELETE and LIMIT

  I recently discovered an unexpected behavior in PostgreSQL involving a pattern of using a Common Table Expression (CTE) with DELETE ... RETURNING and LIMIT to process a batch of items from a queue-like table. What seemed straightforward turned out to have a surprising interaction with the query planner.

• PostgreSQL ☛ pg_auto_reindexer v1.4 released

  This release brings major code refactoring, multiple bugfixes, and introduces a new --jobs option to control the number of parallel workers, enabling faster and more efficient reindexing operations.

• PostgreSQL ☛ pgDay Lowlands in Rotterdam - Call For Presentations (CfP) Closing Soon, and the Call for Sponsors is Open!

  pgDay Lowlands, presented by PostgreSQL Europe, will be at the Blijdorp Zoo in Rotterdam this September 12, 2025!

  This event is suitable for just about any audience, whether you’re a student, open-source enthusiast, decision maker interested in evaluating PostgreSQL as a solution, developer, DBA, or PostgreSQL contributor.

• PostgreSQL ☛ Streaming Data into Postgres with Estuary

  Estuary now provides native support for real-time data streaming into PostgreSQL via its PostgreSQL materialization connector. With this, users can configure Flow collections to automatically write into PostgreSQL tables — in seconds, at scale, and with exactly-once semantics.