Postgres 19 RC1 and what to test now

Together with Postgres 19: What Changed and What to Test Now — With RC1 out and GA due in under a month, Tom Kincaid walks through what survived the reverts and what to try before upgrading, including REPACK (CONCURRENTLY), pg_plan_advice, parallel autovacuum, and logical replication sequence synchronization, each with a 'what to test' checklist. Tom Kincaid (EDB) ⭐ Postgres 19 RC1 was released last week, with an RC2 due November 12 and the final release expected on November 19. 100+ Search Engines. One Simple API — Add live web search to your backend without managing proxies or parsers. SerpApi delivers structured results from Google and other search engines as clean JSON. SerpApi sponsor IN BRIEF: 🇺🇸 Postgres Conference 2027 takes place April 21–23, 2027 in San Jose, California. If you want to speak, its CFP is open until January 31. Who owns an abandoned extension? PGXN's David Wheeler asks pgsql-hackers what the policy should be, after receiving takeover requests and privilege escalation reports for unmaintained extensions. 🇧🇪 FOSDEM PGDay 2027 expands to two days, January 28–29, in Brussels. The CFP is open until December 1. 🇹🇭 FOSSASIA PGDay 2027 takes place on March 9, 2027 in Bangkok. Their CFP is open until November 30. Neon Realtime is now in public beta. You can subscribe to any deterministic SQL query and the result stays live as the data changes. 84% of surveyed Ruby on Rails developers run Postgres in production as per the results of the 2026 Rails Community Survey. How hstore Can Beat jsonb for Audit Logs — depesz saw a post claiming that logging only changed columns from an audit trigger shrank the log 5x but slowed updates. But his own test, using hstore instead of jsonb, made diff logging the fastest variant. Hubert 'depesz' Lubaczewski Why is Postgres's numeric Type So Slow? — A deep dive into numeric's internals explaining why it's slow compared to double precision or DuckDB's integer-backed DECIMAL, and why "just use int128" doesn't fix it. Andrei Lepikhov (pgEdge) 🎧 Postgres FM had Álvaro on the same day for an hour on Citus, StackGres and the thinking behind the benchmark. 📄 Why Materialize Dropped SERIALIZABLE for 3x Write Throughput – Hundreds of thousands of predicate locks sank their Postgres-backed metadata store, so they rebuilt it on READ COMMITTED and proved it correct in Lean. Petros Angelatos 📄 From Alert to Online Repack: A Playbook for Postgres Table Bloat – Build a bloat 'watchdog' with pg_cron and …