Re: explain analyze reports that my queries are fast but they run very slowly - Mailing list pgsql-performance

From Nikolas Everett
Subject Re: explain analyze reports that my queries are fast but they run very slowly
Date
Msg-id CAPmjWd2PTkOfRLFyQ0tfp0dXUb3_GfQO9T2U0m95ejA4sw5LHg@mail.gmail.com
Whole thread Raw
In response to Re: explain analyze reports that my queries are fast but they run very slowly  (Nikolas Everett <nik9000@gmail.com>)
List pgsql-performance
Actually that last paragraph doesn't make much sense.  Please ignore it.


On Thu, Dec 27, 2012 at 12:58 PM, Nikolas Everett <nik9000@gmail.com> wrote:
New news - the hot slave seems to be performing as expected with no long pauses.

It looks like we're using an archive_timeout of 60 seconds and default checkout_timeout and checkpoint_completion_target.  I didn't do any of the research on this.  It seems like we're asking postgres to clear all of the dirty buffers every 60 seconds.  With 48 gigs of shared buffers we could have quite a few buffers to clear.  Is there some place I could check on how all that is going?

On Thu, Dec 27, 2012 at 12:45 PM, Nikolas Everett <nik9000@gmail.com> wrote:
p


pgsql-performance by date:

Previous
From: Nikolas Everett
Date:
Subject: Re: explain analyze reports that my queries are fast but they run very slowly
Next
From: Jeff Janes
Date:
Subject: Re: Why does the query planner use two full indexes, when a dedicated partial index exists?