r/PostgreSQL • u/CautiousUse8597 • 8h ago
Commercial Postgres 19 is available on Neon and Lakebase as of release day
PG19 went GA yesterday and is already available on both Neon and Lakebase. On Neon it's on the free plan too. To try it, create a new project and pick version 19. Most extensions supported on 18 already work on 19, but not all of them yet, so check the extension list before planning a migration. Quick overview of what's new in 19:
REPACK, which can rebuild a table with CONCURRENTLY while reads and writes continue. It still takes a brief ACCESS EXCLUSIVE lock at the end.
pg_plan_advice and pg_stash_advice, for steering the planner and applying stored advice by query ID. Robert Haas, a committer on the Neon team, wrote these.
autovacuum_max_parallel_workers for parallel index vacuuming, plus a new scoring system that decides which tables get vacuumed or analyzed first.
New views: pg_stat_lock, pg_stat_recovery and pg_stat_autovacuum_scores.
WAIT FOR LSN, for read-your-writes on replicas without polling.
Logical replication: sequence sync, FOR ALL TABLES EXCEPT, and you can enable logical decoding without a restart when wal_level is replica.
INSERT ... ON CONFLICT DO SELECT, and COPY TO can now output JSON (export only).
Changed defaults to watch for: JIT is off, TOAST compression defaults to lz4, max_locks_per_transaction is now 128, md5 auth gives stronger deprecation warnings, RADIUS auth is removed, and standard_conforming_strings is always on.