Re: RC2 and open issues

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: RC2 and open issues
Date: 2004-12-21 04:20:46
Message-ID: 2562.1103602846@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> Tom Lane wrote:
>> Exactly. But 1% would be uselessly small with this definition. Offhand
>> I'd think something like 50% might be a starting point; maybe even more.
>> What that says is that a page isn't a candidate to be written out by the
>> bgwriter until it's fallen halfway down the LRU list.

> So we are not scanning by buffer address but using the LRU list? Are we
> sure they are mostly dirty?

No. The entire point is to keep the LRU end of the list mostly clean.

Now that you mention it, it might be interesting to try the approach of
doing a clock scan on the buffer array and ignoring the ARC lists
entirely. That would be a fundamentally different way of envisioning
what the bgwriter is supposed to do, though. I think the main reason
Jan didn't try that was he wanted to be sure the LRU page was usually
clean so that backends would seldom end up doing writes for themselves
when they needed to get a free buffer.

Maybe we need a hybrid approach: clean a few percent of the LRU end of
the ARC list in order to keep backends from blocking on writes, plus run
a clock scan to keep checkpoints from having to do much. But that's way
beyond what we have time for in the 8.0 cycle.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2004-12-21 04:50:10 Re: RC2 and open issues
Previous Message Bruce Momjian 2004-12-21 04:09:28 Re: RC2 and open issues

Browse pgsql-patches by date

  From Date Subject
Next Message Bruce Momjian 2004-12-21 04:50:10 Re: RC2 and open issues
Previous Message Bruce Momjian 2004-12-21 04:09:28 Re: RC2 and open issues