Hubert (depesz) Lubaczewski

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.

Waiting for PostgreSQL 18 – Allow json{b}_strip_nulls to remove null array elements

PostgreSQL 18 adds a new parameter to json{b}_strip_nulls functions to also remove null elements from arrays, enhancing JSON data cleaning.

Waiting for PostgreSQL 18 – Allow parallel CREATE INDEX for GIN indexes

PostgreSQL 18 will introduce parallel CREATE INDEX for GIN indexes, significantly speeding up index builds on large tables.

Waiting for PostgreSQL 18 – Allow EXPLAIN to indicate fractional rows.

PostgreSQL 18 will improve EXPLAIN output by showing fractional row counts with two decimal digits for better query plan accuracy.

Waiting for PostgreSQL 18 – Virtual generated columns

Explains the new virtual generated columns feature in PostgreSQL 18, detailing its syntax, behavior, and current limitations.

Waiting for PostgreSQL 18 – Add delay time to VACUUM/ANALYZE (VERBOSE) and autovacuum logs.

PostgreSQL 18 adds delay time logging to VACUUM/ANALYZE VERBOSE and autovacuum logs, aiding performance monitoring.

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.

Waiting for PostgreSQL 18 – Support RN (roman-numeral format) in to_number().

PostgreSQL 18 adds support for converting Roman numerals to numbers using the to_number() function, filling a long-standing gap.

Waiting for PostgreSQL 18 – Add OLD/NEW support to RETURNING in DML queries.

PostgreSQL 18 adds OLD/NEW support to RETURNING in DML queries, allowing explicit access to previous and new row values.

Waiting for PostgreSQL 18 – Allow changing autovacuum_max_workers without restarting.

PostgreSQL 18 will allow dynamic adjustment of autovacuum_max_workers without a server restart, improving database maintenance flexibility.