Re: Can you spot the difference?

On Tue, Apr 16, 2013 at 7:29 PM, Adrian Klaver <adrian(dot)klaver(at)gmail(dot)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
moshe(at)neadwerx(dot)com | www.neadwerx.com

"Quality is not an act, it is a habit." -- Aristotle