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
ANALYZE ANALYZE — collect statistics about a database Synopsis ANALYZE [ ( option [, ...] ) ] [ table_and_columns [, …| PostgreSQL Documentation
19.10. Vacuuming # 19.10.1. Automatic Vacuuming 19.10.2. Cost-based Vacuum Delay 19.10.3. Default Behavior 19.10.4. Freezing These parameters control vacuuming behavior. For …| PostgreSQL Documentation