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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-performance by date

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