Re: RC2 and open issues - Mailing list pgsql-hackers

From Greg Stark
Subject Re: RC2 and open issues
Date
Msg-id 87oegmfhfb.fsf@stark.xeocode.com
Whole thread Raw
In response to Re: RC2 and open issues  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: RC2 and open issues
List pgsql-hackers
Tom Lane <tgl@sss.pgh.pa.us> writes:

> 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.  

Well if you just keep note of when the last clock scan started then when you
get to the end of the list you've _done_ a checkpoint.

Put another way, we already have such a clock scan, it's called checkpoint.
You could have checkpoint delay between each page write long enough to spread
the checkpoint i/o out over a configurable amount of time -- say half the
checkpoint interval -- and be done with that side of things.

-- 
greg



pgsql-hackers by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Thoughts about updateable views
Next
From: Tom Lane
Date:
Subject: Re: strcoll_l an new approach for locale per column