Postgres Weekly Issue 555: May 15, 2024

#555 — May 15, 2024

Together with

The Draft Postgres 17 Release Notes — Bruce just announced he’s completed the first draft of the release notes for Postgres 17 (due later this year). It’s mostly a bullet-point list of low level improvements for now, but it makes the release feel a lot closer! The first beta is due imminently.

Bruce Momjian

Making a Postgres Query 1,000 Times Faster — If you want to get attention for a blog post, this is the sort of title you need to write! But you also need to back it up with a story, a solution, some useful insights, and perhaps a little humor – thankfully all those elements are present here.

Alejandro García Montoro

Postgres Performance at Any Scale — Deliver consistent database performance and availability through intelligent Indexing and VACUUM advisors and continuous database profiling. pganalyze integrates with Amazon Web Services, Google Cloud Platform, Microsoft Azure, and more.

pganalyze sponsor

Postgres 16.3, 15.7, 14.12, 13.15, and 12.19 Released — Right on schedule, the Postgres team has unveiled new minor versions of each maintained release line. Bug fixes are the focus, but Postgres 14-16 have also received a fix for a security issue with pg_stats_ext and pg_stats_ext_exprs. (Note that Postgres 12 will stop receiving fixes from November this year.)

PostgreSQL Global Development Group

IN BRIEF:

David Wheeler recently did a poll of whether new services for the PGXN v2 Postgres extension project should be written in Go or Rust: Rust was the clear winner.
At Google I/O, Google unveiled Firebase Data Connect, a way to use Firebase with a Postgres instance hosted on Cloud SQL for PostgreSQL.
Philip Marks, a recruiter in the Postgres space, is this week's Postgres Person of the Week.
🇧🇪 Stefan Fercot has some notes from the recent PGConf Belgium event.

What’s New with Postgres at Microsoft, 2024 Edition — Partly thanks to buying Citus Data and partly through Azure, Microsoft is a significant contributor to the Postgres ecosystem these days and this is a surprisingly thorough summary of everything they’ve got going on lately.

Microsoft

Advanced psql Scripting with coproc — coproc is a shell command that runs a process asynchronously in a subshell. If you invoke psql with it, it’s still possible to interact with it from afar and here’s how.

Daniel Vérité

📰 Classifieds

📚 Stay informed about database technology and industry trends with a list of recommended learning resources from Simple Talk editor Louis Davidson.

Your fastest path to production. With Render you can Build, deploy, and scale your apps with unparalleled ease – from your first user to your billionth.

📄 Removing Bloat with the pg_repack Extension – pg_repack is an extension for removing bloat from tables and indexes online without holding exclusive locks. Muhammad Ali

📄 When to Split Patches for Postgres – For those actively contributing to Postgres. Peter Eisentraut

📄 Dealing with Invisible Indexes in an Oracle to Postgres Migration Deepak Mahto

🛠 Code and Tools

pg_lakehouse: Query Any Data Lake from Postgres — An extension that lets you query object stores like S3 and table formats like Delta Lake. Queries are pushed down to Apache DataFusion. Google Cloud Storage and Azure Blob Storage support is promised soon.

ParadeDB

ParadeDB 0.7 – Postgres for search and analytics.
PostgREST 12.0.3 – A REST API for any Postgres database.
Prisma 5.14 – Popular ORM for Node.js and TypeScript.
ScalikeJDBC 4.3 – Database client library for Scala.
DoltgreSQL 0.7 – Version-controlled Postgres-a-like.
pspg 5.8.6 – Unix terminal pager for tabular data.