On Tue, Apr 16, 2013 at 7:29 PM, Adrian Klaver <adrian.kla...@gmail.com>wrote:
> " > 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 2323 Cumberland Parkway, Suite 201 | Atlanta, GA 30339 mo...@neadwerx.com | www.neadwerx.com "Quality is not an act, it is a habit." -- Aristotle