Waiting for PostgreSQL 18 – Non text modes for pg_dumpall, correspondingly change pg_restore
PostgreSQL 18 introduces new non-text dump formats for pg_dumpall and pg_restore, improving performance and flexibility for database backups.
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.
30 articles from this blog
PostgreSQL 18 introduces new non-text dump formats for pg_dumpall and pg_restore, improving performance and flexibility for database backups.
PostgreSQL 18 adds a new parameter to json{b}_strip_nulls functions to also remove null elements from arrays, enhancing JSON data cleaning.
PostgreSQL 18 will introduce parallel CREATE INDEX for GIN indexes, significantly speeding up index builds on large tables.
PostgreSQL 18 will improve EXPLAIN output by showing fractional row counts with two decimal digits for better query plan accuracy.
Explains the new virtual generated columns feature in PostgreSQL 18, detailing its syntax, behavior, and current limitations.
PostgreSQL 18 adds delay time logging to VACUUM/ANALYZE VERBOSE and autovacuum logs, aiding performance monitoring.
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.