Greetings,
Three'ish more questions:
When restoring a table from backup (using pg_dump and pg_restore), are there reasons, other than restoration performance, to defer index restoration until after the COPY is complete?
As we understand it, an ANALYZE is necessary, regardless if we restore to a table with preexisting indexes or one that's had indexes added after the fact. Is this correct? Put slightly a different way, do CREATE INDEX and/or REINDEX operations cause stats updates?