From: | Greg Stark <gsstark(at)mit(dot)edu> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: RC2 and open issues |
Date: | 2004-12-22 16:04:24 |
Message-ID: | 87oegmfhfb.fsf@stark.xeocode.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2004-12-22 16:19:16 | Re: strcoll_l an new approach for locale per column |
Previous Message | Richard Huxton | 2004-12-22 15:20:43 | Re: Thoughts about updateable views |
From | Date | Subject | |
---|---|---|---|
Next Message | David Brown | 2004-12-22 20:10:53 | Allow pooled connections to list all prepared queries |
Previous Message | Euler Taveira de Oliveira | 2004-12-22 05:05:09 | Re: uptime function to postmaster |