Tobias Brox <tobixen(at)gmail(dot)com> 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.
In response to
pgsql-performance by date
|Next:||From: Tobias Brox||Date: 2010-09-23 21:50:38|
|Subject: Memory usage - indexes|
|Previous:||From: Tobias Brox||Date: 2010-09-23 20:47:26|
|Subject: Re: locking issue on simple selects?|