Re: locking issue on simple selects? - Mailing list pgsql-performance

From Kevin Grittner
Subject Re: locking issue on simple selects?
Date
Msg-id 4C9B935D0200002500035C76@gw.wicourts.gov
Whole thread Raw
In response to Re: locking issue on simple selects?  (Tobias Brox <tobixen@gmail.com>)
List pgsql-performance
Tobias Brox <tobixen@gmail.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

pgsql-performance by date:

Previous
From: Tobias Brox
Date:
Subject: Re: locking issue on simple selects?
Next
From: adrian.kitchingman@dse.vic.gov.au
Date:
Subject: postgresql-9.0 Windows service stops after database transaction