Re: Load Distributed Checkpoints, take 3 - Mailing list pgsql-patches

From Greg Smith
Subject Re: Load Distributed Checkpoints, take 3
Date
Msg-id Pine.GSO.4.64.0706260039110.12069@westnet.com
Whole thread Raw
In response to Re: Load Distributed Checkpoints, take 3  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-patches
On Mon, 25 Jun 2007, Tom Lane wrote:

> right now, BgBufferSync starts over from the current clock-sweep point
> on each call --- that is, each bgwriter cycle.  So it can't really be
> made to write very many buffers without excessive CPU work.  Maybe we
> should redefine it to have some static state carried across bgwriter
> cycles

The LRU portion restarts like that, and it's certainly not optimal.  But
the auto-tuning LRU patch that's already near application makes this much
less of an issue because it only does real work when buffers have been
allocated, so the sweep point will have moved along.  I'll add this idea
to my list of things that would be nice to have as part of a larger
rewriter, I think it's more trouble than it's worth to chase right now.

--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD

pgsql-patches by date:

Previous
From: Tom Lane
Date:
Subject: Re: Load Distributed Checkpoints, take 3
Next
From: Greg Smith
Date:
Subject: Re: Load Distributed Checkpoints, take 3