Neues vom PostgreSQL Planet

New podcast episode published by Claire Giordano from her series “Talking Postgres” : Building a dev experience for Postgres in VS Code with Rob Emanuele

Blog posts

• Ellyne Phneah Key takeaways from the PostgreSQL & AI Summit: RAG, agents, and tuning

PostgreSQL 19 changes this week EXPLAIN wal_fpi_bytes value exposed in EXPLAIN (WAL) pg_stat_wal column wal_fpi_bytes added pg_stat_get_backend_wal() output column wal_fpi_bytes added psql prompt configuration option %S added, showing the current value of search_path PostgreSQL 19 articles Waiting for PostgreSQL 19 – Add psql PROMPT variable for search_path.

Postgres has an awesome amount of data collected in its own internal tables. Postgres hackers know all about this  - but software developers and folks working with day to day Postgres tasks often miss out the good stuff.

The Postgres catalog is how Postgres keeps track of itself. Of course, Postgres would do this in a relational database with its own schema. Throughout the years several nice features have been added to the internal tables like psql tools and views that make navigating Postgres’ internal tables even easier.

I'm happy to announce release 0.8 of pg_statviz, the minimalist extension and utility pair for time series analysis and visualization of PostgreSQL internal statistics.

This release adds support for PostgreSQL 18, adapting to significant catalog view changes introduced in this release:

PostgreSQL 13 will officially reach End-of-Life (EOL) on November 13, 2025. After this date, the PostgreSQL Global Development Group will stop releasing security patches and bug fixes for this version. That means if you’re still running PostgreSQL 13, you’ll soon be on your own with no updates, no community support, and growing security risks. Why […]

In the third installment of the PostGIS Performance series, I wanted to talk about performance around bounding boxes.

Geometry data is different from most column types you find in a relational database. The objects in a geometry column can be wildly different in the amount of the data domain they cover, and the amount of physical size they take up on disk.

PostgreSQL 19 changes this week ALTER SUBSCRIPTION : REFRESH SEQUENCES syntax added error_on_null() added for checking if the input is the NULL value COPY TO now works with partitioned tables full text search : database default collation now used for parsing psql : Improve tab completion for large objects. PostgreSQL 19 articles PostgreSQL 18 articles Waiting for PostgreSQL 19 – Support COPY TO for partitioned tables. (2025-10-22) - Hubert 'depesz' Lubaczewski Say Hello to OIDC in PostgreSQL 18!