Re: [HACKERS] Slow count(*) again...

Conor Walsh <ctw@adverb.ly>

From: Conor Walsh <ctw@adverb.ly>

To: Robert Haas <robertmhaas@gmail.com>

Cc: "pgsql-performance@postgresql.org" <pgsql-performance@postgresql.org>

Date: 2011-02-04T02:12:57Z

Lists: pgsql-hackers, pgsql-performance

> I can't remember
> anyone ever complaining "ANALYZE took too long to run".  I only
> remember complaints of the form "I had to remember to manually run it
> and I wish it had just happened by itself".

Robert,

This sounds like an argument in favor of an implicit ANALYZE after all
COPY statements, and/or an implicit autoanalyze check after all
INSERT/UPDATE statements.

-Conor