#​583 — January 9, 2025

Web Version

Happy New Year! In case you missed our previous issue, we've moved Postgres Weekly to Thursdays to better catch the latest Postgres news (a lot of big releases were happening on Wednesdays), so we're now back with you every Thursday till spring :-)
__
Peter Cooper

Together with  Microsoft logo

Postgres Weekly

PIG: A New Package Manager for Postgres — Postgres Install Genius is a new package manager built to make it easier to get hundreds of Postgres extensions up and running on a mainstream Linux-based Postgres install. It’s from the Pigsty folks, but doesn’t require using their specialized Postgres distribution. Note that this is just one of a variety of similar efforts and is not an official solution.

Pigsty

How to Fix a Common Cause of Slow Queries in Postgres — A database engineer at the Render cloud platform shows off a commonly encountered, but trivially fixed, performance issue caused by missing indexes on foreign keys.

Eric Fritz

POSETTE 2025: Call for Proposals (CFP) is Open! — POSETTE: An Event for Postgres, a free & virtual developer event organized by the Postgres team at Microsoft, is happening June 10-12. The CFP is open until February 9. New and experienced speakers are encouraged to submit! Get the details.

Microsoft sponsor

QUICK BITS:

Postgres 18 to Get Backend-Level Statistics — Barring any unforeseen problems, Postgres 18 (likely due late in 2025) will be gaining some improved backend statistics, including a new pg_stat_get_backend_io function to see the I/O activity in each server backend.

Bertrand Drouvot

📄 The Challenges of Postgres Containers – “Combined with a good Kubernetes operator, Postgres containers are production ready today.” Jeremy Schneider

📄 Running an Async Web Query Queue with Procedures and pg_cron Paul Ramsey

📄 Waiting for Postgres 18: Add UUID Version 7 Generation Function Hubert depesz Lubaczewski

📄 Why We Ditched etcd for Postgres for Storing Metadata RisingWave Labs

📄 Why Isn’t My Query Benefiting from Partition Pruning? Shane Borden

📄 How to Tell What Port Postgres is Running On Semab Tariq

🛠 Code and Tools

PostgreSQL Anonymizer 2.0: Data Masking for Postgres — Rather than simply anonymizing dumps, this extension takes anonymization directly to your database by having you declare masking rules directly against your schema. Version 2.0 is a complete rewrite using Rust and PGRX and features improved fake data generation, role-based transparent dynamic masking, anonymized exports with pg_dump, and more.

Dalibo

pgspot 0.9: Spot Vulnerabilities in Postgres Extension Scripts — Created by a Timescale engineer for finding vulnerabilities in TimescaleDB, this is an analysis tool for SQL scripts that checks for vulnerabilities and best practices. v0.9 bumps it up to the Postgres 17 parser and fixes some bugs.

Sven Klemm (Timescale)

SQLite Foreign Data Wrapper for Postgres v2.5 — Requires a Linux or POSIX-compliant system, but now supports Postgres 17 as well as some extra data types like uuid, bit and varbit.

PGSpider

Sqitch 1.5: Database Change Management Tool — A database and framework independent (Postgres 8.4+ is supported) system for managing database and schema changes via SQL scripts. Here’s how it works with Postgres.

Sqitch