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: 4C9B788A0200002500035C5F@gw.wicourts.gov (view raw or flat)
Thread:
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.
 
-Kevin

In response to

Responses

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-2014 The PostgreSQL Global Development Group