Re: Autoanalyze and OldestXmin

From: Pavan Deolasee <pavan(dot)deolasee(at)gmail(dot)com>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Greg Stark <stark(at)mit(dot)edu>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Autoanalyze and OldestXmin
Date: 2011-06-09 14:52:59
Message-ID: 92E3A92E-D555-46DC-80B2-01590E59063A@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2011-06-09 14:55:45 Re: literature on write-ahead logging
Previous Message Tom Lane 2011-06-09 14:46:36 Re: release slippage