Looking back since beta3 (August 13), what is in Postgres 19rc2 and what is not?
✅ still there in rc2
❌ in beta3, gone in rc2
🆕 new in rc2
Performance
✅ Async I/O workers that scale between `io_min_workers` and `io_max_workers`
✅ Parallel autovacuum
✅ `REPACK`, including `CONCURRENTLY`
✅ `pg_plan_advice` and `pg_stash_advice`
Developer Experience
❌ SQL/PGQ property graph queries
❌ `UPDATE ... FOR PORTION OF`
❌ `ALTER TABLE ... MERGE PARTITIONS` and `SPLIT PARTITION`
❌ SQL functions that return the DDL for roles, databases and tablespaces
✅ `INSERT ... ON CONFLICT DO SELECT`
✅ String functions in `jsonpath`
✅ `random()` for dates and timestamps
✅ Read-your-writes on replicas by waiting for an LSN
Security
✅ `password_expiration_warning_threshold`
✅ `md5_password_warnings`
Monitoring
✅ `pg_stat_lock` and `pg_stat_recovery`
✅ `started_by` and `mode` in `pg_stat_progress_vacuum`
✅ `EXPLAIN (ANALYZE, IO)`
❌ `pg_stat_progress_data_checksums`
Logical Replication
✅ `CREATE PUBLICATION ... EXCEPT`
✅ `CREATE SUBSCRIPTION ... SERVER`
✅ `effective_wal_level`
Defaults and Other Changes
❌ Online enabling and disabling of data checksums
✅ JIT is off by default
✅ `default_toast_compression` defaults to `lz4`
✅ still there in rc2
❌ in beta3, gone in rc2
🆕 new in rc2
Performance
✅ Async I/O workers that scale between `io_min_workers` and `io_max_workers`
✅ Parallel autovacuum
✅ `REPACK`, including `CONCURRENTLY`
✅ `pg_plan_advice` and `pg_stash_advice`
Developer Experience
❌ SQL/PGQ property graph queries
❌ `UPDATE ... FOR PORTION OF`
❌ `ALTER TABLE ... MERGE PARTITIONS` and `SPLIT PARTITION`
❌ SQL functions that return the DDL for roles, databases and tablespaces
✅ `INSERT ... ON CONFLICT DO SELECT`
✅ String functions in `jsonpath`
✅ `random()` for dates and timestamps
✅ Read-your-writes on replicas by waiting for an LSN
Security
✅ `password_expiration_warning_threshold`
✅ `md5_password_warnings`
Monitoring
✅ `pg_stat_lock` and `pg_stat_recovery`
✅ `started_by` and `mode` in `pg_stat_progress_vacuum`
✅ `EXPLAIN (ANALYZE, IO)`
❌ `pg_stat_progress_data_checksums`
Logical Replication
✅ `CREATE PUBLICATION ... EXCEPT`
✅ `CREATE SUBSCRIPTION ... SERVER`
✅ `effective_wal_level`
Defaults and Other Changes
❌ Online enabling and disabling of data checksums
✅ JIT is off by default
✅ `default_toast_compression` defaults to `lz4`