Re: explain analyze reports that my queries are fast but they run very slowly

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Actually that last paragraph doesn't make much sense.  Please ignore it.


On Thu, Dec 27, 2012 at 12:58 PM, Nikolas Everett <nik9000@xxxxxxxxx> 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@xxxxxxxxx> wrote:
p



[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux