Re: locking issue on simple selects?

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

 



Tobias Brox <tobixen@xxxxxxxxx> wrote:
 
> All while having this problem, there was one heavy query running
> in parallell ... not sure if that's relevant.
 
Have you turned on checkpoint logging?  You might want to see if
these are happening at some particular point in the checkpoint
processing.  If so, look through the archives for posts from Greg
Smith on how to tune that -- he's worked out a nice methodology to
iteratively improve your configuration in this regard.
 
-Kevin

-- 
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance


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

  Powered by Linux