On 09-Jun-2011, at 8:29 PM, Tom Lane <t...@sss.pgh.pa.us> wrote:
> Robert Haas <robertmh...@gmail.com> writes: >> On Thu, Jun 9, 2011 at 10:52 AM, Pavan Deolasee >> <pavan.deola...@gmail.com> wrote: >>>> 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 > >> Wow, that's slow. Still, what if the user were doing a transaction of >> comparable size? It's not like ANALYZE is doing a gigantic amount of >> work. > > I wonder what vacuum cost delay settings are in use ... > Default settings with 512Mb shared buffers Thanks. Pavan -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
