PostgreSQL 19 tour demos new SQL, REPACK, and replication
Original title: PostgreSQL 19: A hands-on tour with runnable browser examples
A browser sandbox runs PostgreSQL 19.0, released 19 November 2026, with disposable primary and replica experiments.
A Certuvia walkthrough invites readers to try PostgreSQL 19 SQL and maintenance features in a browser against a real PostgreSQL 19 server. Covered items include IGNORE NULLS, get-or-create inserts, JSON export, JSONPath, range subtraction, native REPACK, autovacuum priority scores, and logical and physical replication. The post says PostgreSQL 19.0 was released 19 November 2026 and points readers to the release notes for the full changelog.
- The sandbox role is student on database blog_lab, without administrative credentials.
- Logical subscriber uses port 5433 and physical standby uses 5434, fed by a primary on 5432.
- Only one extra replica instance runs at a time because of the guest memory budget.
- Native REPACK can run concurrently; PostgreSQL 18 is compared with VACUUM FULL and pg_repack.
- Products
- PostgreSQL
From the original article
13 min read at certuvia.comPostgreSQL 19 brings useful new SQL alongside maintenance and replication improvements. Try IGNORE NULLS , get-or-create inserts , JSON export , JSONPath transformations , and range subtraction , then explore planner advice and real replication. PostgreSQL 19.
By petrpravda · certuvia.com
A short excerpt; the article and its images belong to the publisher. Summary, key facts and assessment above are AI-written from the article and can be wrong.