Skip site navigation (1) Skip section navigation (2)

Re: locking issue on simple selects?

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Tobias Brox" <tobixen(at)gmail(dot)com>, <pgsql-performance(at)postgresql(dot)org>
Subject: Re: locking issue on simple selects?
Date: 2010-09-23 20:55:54
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
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 BroxDate: 2010-09-23 21:50:38
Subject: Memory usage - indexes
Previous:From: Tobias BroxDate: 2010-09-23 20:47:26
Subject: Re: locking issue on simple selects?

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group