Skip to content
NewA calmer, faster ZeroHour
Otherinfo

PostgreSQL 19 tour demos new SQL, REPACK, and replication

Original title: PostgreSQL 19: A hands-on tour with runnable browser examples

Hacker News · securityby petrpravda ()13 min read1
Part of a story covered by 2 sourcesMerged summary & timeline
AI summary · x-ai/grok-4.7Summaries by Vani AI

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.

Key facts
  • 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.
Analyze this story with Vani AIImpact, who is affected and what defenders should do, in a new chat

From the original article

13 min read at certuvia.com

PostgreSQL 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.

Hacker News · security

By petrpravda · certuvia.com

Read the full article at Hacker News · security

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.