Include ANALYZE steps in all dumps, part 2

session summary

Part two implemented the pg_dump side of per-object ANALYZE. The group modeled ANALYZE as a new dumpable archive object, dependent on its table and emitted in the post-data section after data and indexes. They limited the first prototype to ordinary tables and materialized views, excluding sequences, views, and foreign tables. The code compiled, but no ANALYZE appeared in output because the new object was not reached or enabled correctly; print debugging exposed control-flow problems, and they deferred completion.

timecodes

1. 01:00 Resuming from pg_dump archive entries
2. 05:00 Creating a dumpable ANALYZE object
3. 08:30 Tables, partitions, foreign tables, and sequences
4. 15:30 Object IDs and table dependencies
5. 18:00 Choosing an ArchiveEntry implementation
6. 27:00 Building the ANALYZE command in post-data
7. 30:30 Enabling ANALYZE and considering opt-out
8. 38:00 Compilation succeeds, output debugging begins