" The autovacuum daemon, if enabled, will automatically issue ANALYZE commands whenever the content of a table has changed sufficiently. However, administrators might prefer to rely on manually-scheduled ANALYZE operations, particularly if it is known that update activity on a table will not affect the statistics of "interesting" columns. The daemon schedules ANALYZE strictly as a function of the number of rows inserted or updated; it has no knowledge of whether that will lead to meaningful statistical changes. "
So at a guess there has not been enough churn on the table.
So pg_restore's COPY would not trigger the ANALYZE? That seems wrong.
--
Moshe Jacobson Nead Werx, Inc. | Manager of Systems Engineering
