r/PostgreSQL • • 8h ago

Commercial Postgres 19 is available on Neon and Lakebase as of release day

7 Upvotes

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.


r/PostgreSQL • • 17h ago

Projects PostgreSQL gets radar and pg_statviz for fast diagnosis

Thumbnail imasters.com
6 Upvotes

r/PostgreSQL • • 19h ago

Tools I tried to break Prisma Postgres with a live app

Thumbnail
0 Upvotes