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>
Cc: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: locking issue on simple selects?
Date: 2010-09-23 22:50:21
Message-ID: 4C9B935D0200002500035C76@gw.wicourts.gov (view raw or flat)
Thread:
Lists: pgsql-performance
Tobias Brox <tobixen(at)gmail(dot)com> wrote:
 
> 13:19:13.840 - LOG: checkpoint complete
 
> 13:19:13.841 - LOG:  checkpoint starting
 
> 13:20:43.176 - LOG:  checkpoint complete
 
There wasn't a lot of time between the completion of one checkpoint
and the start of the next.  And the two checkpoints finished a
minute and a half apart.  Perhaps you need to boost your
checkpoint_segments setting?  What is it now?
 
-Kevin

In response to

pgsql-performance by date

Next:From: adrian.kitchingmanDate: 2010-09-24 04:39:48
Subject: postgresql-9.0 Windows service stops after database transaction
Previous:From: Tobias BroxDate: 2010-09-23 22:25:36
Subject: Re: locking issue on simple selects?

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