Real-Time Database Events with pg_eventserv — pg_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 DuckDB — DuckDB (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

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.

Percona

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

Dynaboard sponsor

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

Stefan Fercot