Waiting for PostgreSQL 18 – Add cost-based vacuum delay time to progress views.
PostgreSQL 18 adds tracking of cost-based vacuum delay time to progress views, helping monitor performance impact of vacuum operations.
Hubert (depesz) Lubaczewski is a PostgreSQL expert and developer sharing practical tips on database management, query optimization, and tooling. His blog covers PostgreSQL performance, CSV handling, T-SQL formatting, and real-world database workflows.
44 articles from this blog
PostgreSQL 18 adds tracking of cost-based vacuum delay time to progress views, helping monitor performance impact of vacuum operations.
PostgreSQL 18 adds support for converting Roman numerals to numbers using the to_number() function, filling a long-standing gap.
PostgreSQL 18 adds OLD/NEW support to RETURNING in DML queries, allowing explicit access to previous and new row values.
PostgreSQL 18 will allow dynamic adjustment of autovacuum_max_workers without a server restart, improving database maintenance flexibility.