hn.today

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

certuvia.com49 points4 comments
Screenshot of PostgreSQL 19: A hands-on tour with runnable browser examples

This is a runnable tour of PostgreSQL 19, released November 19, 2026, built around a real server in a disposable browser-based sandbox. It starts by checking the server version and SQL role, then explains how to experiment safely and why the examples do not replace a genuine PostgreSQL 18 comparison: meaningful performance tests require separate servers with matched data, settings, hardware, and cache conditions. Maintenance examples show how native REPACK rewrites a bloated table to return space to the operating system, including a concurrent mode that captures writes but still takes a brief lock for the final swap. The tour also inspects per-table autovacuum scores and introduces planner advice that can constrain a query’s plan and report whether the advice matched.

A detailed replication exercise runs a publisher and subscriber as separate PostgreSQL processes, showing publication table exclusions, sequence publication, and REFRESH SEQUENCES to catch up sequence state after values advance. PostgreSQL 19 can enable logical WAL when a publication requires it, avoiding a primary restart. The remaining experiments cover WAIT, EXPLAIN I/O, foreign keys, IGNORE NULLS, get-or-create inserts, JSON export and import with COPY, partitioned COPY, JSONPath transformations, range subtraction, generated random dates and timestamps, binary values, catalog identities, CHECK constraints, NOT IN, eager aggregation, and defaults and diagnostics. Each section offers executable SQL and comparison guidance, emphasizing what changed and what to inspect rather than presenting small demo tables as benchmarks.

Read on certuvia.com4 comments on Hacker News

Summary generated by AI from the linked article. hn.today is not affiliated with Hacker News or Y Combinator.

More in Programming

The daily digest

Today's best Hacker News stories, summarized and screenshotted, one email a day.