The Hidden Cost of Postgres Arrays — If you’ve ever used array data types in your tables but not thought deeply about the tradeoffs versus other approaches, Radim shares some insights that could save you from some subtle issues in production.

Radim Marek

Enterprise Grade Postgres for Agentic AI, High Availability and More — pgEdge, the leading open source enterprise Postgres company, makes it easy for developers to build and deploy highly scalable and distributed database applications across global networks.

pgEdge sponsor

Integer Overflow in Sequence-Generated Primary Keys — If you use bigint for a sequence, you could generate a million a second for almost 300,000 years without problems, but if you’re using serial/integer, you’d overflow in hours at such a rate! Most tables don’t contain billions of rows, but Laurenz has a neat query to look for the problem and some steps you can take to resolve it.

Laurenz Albe

Using Postgres as a Graph Database: Who Grabbed a Beer Together? — A practical look at the opportunities Apache AGE opens up by bringing graph database concepts and querying natively to Postgres.

Taras Kloba

Barman 3.17.0: Backup and Recovery Manager for Postgres — An admin tool for disaster recovery of Postgres servers enabling remote backups and restoration of multiple servers. v3.17.0 now supports operations on inactive/disabled servers and deprecates custom compression for WAL files.

EnterpriseDB UK Limited

pg_textsearch 0.4: Modern Ranked Text Search Extension — A Postgres extension that brings powerful BM25 ranking to full text search. v0.4 introduces index compression, boasting ~40% smaller indexes “thanks to delta encoding and bitpacking.”

Tiger Data