Neues vom PostgreSQL Planet

A modern-day Postgres instance creates robust and comprehensive logs for nearly every facet of database and query behavior. While Postgres logs are the go-to place for finding and debugging critical errors, they are also a key tool in application performance monitoring.

When many sessions try to insert into the same B-tree leaf page, classic exclusive page locking serializes progress and wastes time on sleep/wake cycles. We’re introducing a batch page insertion path that lets the session holding the page lock insert for itself and its neighbors. The result: dramatically reduced lock waits, and big gains at high client counts (2X throughput boost starting from 64 clients in our benchmark).

pgsql_tweaks is a bundle of functions and views for PostgreSQL

One could install the whole package, or just copy what is needed from the source code.

The extension is also available on PGXN.

The extension is also availabe through the PostgreSQL rpm packages.

General changes

No code has been changed.

PostgreSQL 19 changes this week pg_stat_statements counters for generic and custom plans added EXPLAIN memoize planner estimates now displayed logging misleading hint about buggy kernels for "unexpected data beyond EOF" error removed PostgreSQL 18 changes this week pg_dumpall support for non-text modes added to (and corresponding support in pg_restore ) has been reverted due to concerns about robustness and security; it is hoped this feature can be re-added in PostgreSQL 19.

The PostGIS Team is pleased to release PostGIS 3.6.0rc1! Best Served with PostgreSQL 18 Beta3 and soon to be released GEOS 3.14.

This version requires PostgreSQL 12 - 18beta3, GEOS 3.8 or higher, and Proj 6.1+. To take advantage of all features, GEOS 3.14+ is needed. To take advantage of all SFCGAL features, SFCGAL 2.2.0+ is needed.

pgsql_tweaks is a bundle of functions and views for PostgreSQL

One could install the whole package, or just copy what is needed from the source code.

The extension is also available on PGXN.

The extension is also availabe through the PostgreSQL rpm packages.