From: | Jim Nasby <decibel(at)decibel(dot)org> |
---|---|
To: | Greg Smith <gsmith(at)gregsmith(dot)com> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Bgwriter LRU cleaning: we've been going at this all wrong |
Date: | 2007-06-29 13:07:34 |
Message-ID: | FF080A7B-9AFE-4E7E-96FF-D7048048D70D@decibel.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Jun 26, 2007, at 11:57 PM, Greg Smith wrote:
> On Wed, 27 Jun 2007, ITAGAKI Takahiro wrote:
>
>> It might be good to use statistics information about buffer usage
>> to modify X runtime.
>
> I have a complete set of working code that tracks buffer usage
> statistics as the background writer scans, so that it has an idea
> what % of the buffer cache is dirty, how many pages have each of
> the various usage counts, that sort of thing. The problem was that
> the existing BGW mechanisms were so clumsy and inefficient that
> giving them more information didn't make them usefully smarter.
> I'll revive that code again if it looks like it may help here.
Even if it's not used by bgwriter for self-tuning, having that
information available would be very useful for anyone trying to hand-
tune the system.
--
Jim Nasby jim(at)nasby(dot)net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
From | Date | Subject | |
---|---|---|---|
Next Message | Bernd Helmle | 2007-06-29 13:09:30 | pg_dump and minor versions |
Previous Message | Theo Schlossnagle | 2007-06-29 12:33:43 | Re: [PATCHES] Doc update for pg_start_backup |