September 25th marks the release of PostgreSQL 18. This article covers the March CommitFest and concludes the series covering the new features of the upcoming update. This article turned out quite large, as the last March CommitFest is traditionally the biggest and richest in new features. You can find previous reviews of PostgreSQL 18 CommitFests here: 2024-07 , 2024-09 , 2024-11 , 2025-01 . Client and Server Applications pg_dump[all]/pg_restore: dump and restore statistics Collect statistic...| postgrespro.com
VACUUM VACUUM — garbage-collect and optionally analyze a database Synopsis VACUUM [ ( option [, ...] ) ] [ table_and_columns …| PostgreSQL Documentation
ALTER TABLE ALTER TABLE — change the definition of a table Synopsis ALTER TABLE [ IF EXISTS ] [ ONLY …| PostgreSQL Documentation
19.7. Query Planning # 19.7.1. Planner Method Configuration 19.7.2. Planner Cost Constants 19.7.3. Genetic Query Optimizer 19.7.4. Other Planner Options 19.7.1. Planner …| PostgreSQL Documentation
CLUSTER CLUSTER — cluster a table according to an index Synopsis CLUSTER [ ( option [, ...] ) ] [ …| PostgreSQL Documentation
ANALYZE ANALYZE — collect statistics about a database Synopsis ANALYZE [ ( option [, ...] ) ] [ table_and_columns [, …| PostgreSQL Documentation