PostgreSQL 19
PostgreSQL 19 (released November 19, 2026) is a major open‑source database release introducing an online REPACK command (including REPACK (CONCURRENTLY)), planner‑stability tooling and automated plan application, expanded autovacuum parallelism controls, new monitoring views, and various SQL and I/O improvements. The release focuses on safer online table maintenance and more stable, controllable query planning for production deployments across WiKey Specifications
- Release date:November 19, 2026
- New maintenance command:REPACK and REPACK (CONCURRENTLY) — online table reorganization and space reclamation
- Planner control:pg_plan_advice extension to stabilize/control planner decisions
- Automatic plan application:pg_stash_advice extension to save/apply plan advice by query identifier
- Autovacuum:autovacuum_max_parallel_workers parameter and parallel index cleanup
- Monitoring:New views such as pg_stat_progress_repack, pg_stat_lock, pg_stat_recovery, pg_stat_autovacuum_scores
- Platforms:Windows, Linux, macOS (installers, tools and source provided)
Official product pagehttp://www.ithome.com — Original source
Group Feed
-
苏星宇-V posted an update in the group
PostgreSQL 19 21 hours agoPostgreSQL 19 — non‑blocking repacks, planner advice, and read‑your‑writes on st
PostgreSQL 19 — non‑blocking repacks, planner advice, and read‑your‑writes on st
PostgreSQL 19 was released by the PostgreSQL Global Development Group on November 19, 2026. This major release adds REPACK (CONCURRENTLY) to reclaim table bloat without blocking reads/writes, the pg_plan_advice (and pg_stash_advice) extensions to stabilize or…