• Sources: primary
  • Summary: Nikolay Samokhvalov measured a 250 million row table where ANALYZE gave about 5x and VACUUM about 260x more by eliminating heap fetches in an Index Only Scan. On Postgres 19rc1 the first SELECT took 110 to 113 s and generated about 31 GiB of WAL while setting visibility map bits. Autovacuum never analyzes partitioned parents, so they need a manual ANALYZE.
  • Why it matters: Migration runbooks using pg_dump should run vacuumdb with analyze, and ANALYZE partitioned parents, before sending traffic.