Re: Autoanalyze and OldestXmin - Mailing list pgsql-hackers

From Pavan Deolasee
Subject Re: Autoanalyze and OldestXmin
Date
Msg-id 92E3A92E-D555-46DC-80B2-01590E59063A@gmail.com
Whole thread Raw
In response to Re: Autoanalyze and OldestXmin  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: Autoanalyze and OldestXmin
List 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
factorand 50 clients 

Thanks,
Pavan

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: release slippage
Next
From: Robert Haas
Date:
Subject: Re: literature on write-ahead logging