✏️ Please note that next week we may delay Postgres Weekly until Thursday, October 13 due to the expected final release of Postgres 15.

#​474 — October 5, 2022

Web Version

Together with  Timescale logo

Postgres Weekly

Real-Time Database Events with pg_eventservpg_eventserv is a new Go-powered server that takes events from Postgres via NOTIFY and then passes those events to waiting WebSocket clients. “Building real-time systems this way allows any database client to alter the state of the system and have that alteration propagated to all other clients in real time.”

Paul Ramsey (Crunchy Data)

PostgreSQL 15 Release Candidate 1 Released — For the past several years, major Postgres releases have arrived around early October and we’re now counting down to Postgres 15’s final release on October 13. This release candidate aims to be “mostly identical” to the final release but provides an opportunity to test and catch last minute bugs, and get extensions running smoothly. Here are the release notes, as they stand.

PostgreSQL Global Development Group

How TimescaleDB Expands PostgreSQL Performance — Learn how TimescaleDB expands PostgreSQL query performance by 1000x, reduces storage utilization by 90%, and provides time-saving features for time-series and analytical applications—while still being 100% Postgres.

Timescale sponsor

Querying Postgres Tables Directly from DuckDBDuckDB (an in-process SQL OLAP database that could perhaps be called a ‘SQLite for analytics’) can now directly read Postgres tables while Postgres is running, and run queries to speed up complex analytical queries without duplicating data.

Hannes Mühleisen (DuckDB)


Are the Majority of Postgres Servers on the Internet Insecure?“At most 15% of the approximately 820,000 PostgreSQL servers listening on the Internet require encryption,” claims the author, but he goes further than that by looking at how some Postgres clients don’t help matters by defaulting to not using encryption even when it’s possible. (We think ‘on the Internet’ is doing some heavily lifting in the title, though, as Postgres servers are often behind firewalls, in private networks, and the like.)

Jonathan Mortensen

How to Get Into Understanding Postgres' Internals — If you want to work deep in the Postgres codebase, Paul shares some pointers to handy resources for learning about how Postgres ticks from the inside.

Paul Ramsey

Why Didn't VACUUM Make Your Table Smaller? — If you’ve ever asked this question, this introduction to what’s going on is for you. In short, you need VACUUM FULL – but there are tradeoffs and alternatives to consider.

Hans-Jürgen Schönig

🛠 Code and Tools

pg_stat_monitor 1.1.0: A Query Performance Monitoring Tool — Aims to be an ‘advanced replacement’ for the universally popular pg_stat_statements for digging into query origins, execution, planning statistics and details, and more. Percona has written about how it works before.


Dynaboard: The Pro-Code Web App Builder Made for Developers

Dynaboard sponsor

pgBackRest 2.41: Reliable Postgres Backup and RestoreBackup annotations is a new feature for attaching informative key/value pairs to backups to provide extended information.

Stefan Fercot