Sunday, September 28, 2008

Re: [PERFORM] Slow updates, poor IO

On Sep 28, 2008, at 10:01 PM, John Huttley wrote:

> Greg Smith wrote:
>> On Mon, 29 Sep 2008, John Huttley wrote:
>>> checkpoint _segments=16 is fine, going to 64 made no improvement.
>> You might find that it does *after* increasing shared_buffers. If
>> the buffer cache is really small, the checkpoints can't have very
>> much work to do, so their impact on performance is smaller. Once
>> you've got a couple of hundred MB on there, the per-checkpoint
>> overhead can be considerable.
> Ahh bugger, I've just trashed my test setup.

Pardon? How did you do that?

Dan Langille

Sent via pgsql-performance mailing list (
To make changes to your subscription:

No comments: