Timeline:
- Oct 3: Learning about this issue
- Tweet: https://x.com/andatki/status/1841915460062769187
- Reviewing commit: https://github.com/postgres/postgres/commit/62ddf7ee9a399e0b9624412fc482ed7365e38958
- Summarizing thoughts below
Goal: Understand WHY to ANALYZE ONLY
on a root partition table.
The current version (17) documentation seems to be wrong. It says only the root table is analyzed, but in the commit message David Rowley describes the partitions of the root table are also analyzed when ANALYZE runs on the root.