Re: Autoanalyze and OldestXmin

Pavan Deolasee <pavan.deolasee@gmail.com>

From: Pavan Deolasee <pavan.deolasee@gmail.com>

To: Robert Haas <robertmhaas@gmail.com>

Cc: Tom Lane <tgl@sss.pgh.pa.us>, Greg Stark <stark@mit.edu>, pgsql-hackers <pgsql-hackers@postgresql.org>

Date: 2011-06-09T14:52:59Z

Lists: pgsql-hackers


> 
> I am wondering if we shouldn't be asking ourselves a different
> question: why is ANALYZE running long enough on your tables for this
> to become an issue?  How long is it taking?
> 

The log file attached in the first post has the details; it's taking around 5 mins for the accounts table with 50 scale factor and 50 clients

Thanks,
Pavan