Re: Bgwriter LRU cleaning: we've been going at this all wrong

From: Greg Smith <gsmith(at)gregsmith(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Bgwriter LRU cleaning: we've been going at this all wrong
Date: 2007-06-27 04:57:30
Message-ID: Pine.GSO.4.64.0706270049000.10954@westnet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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.

--
* Greg Smith gsmith(at)gregsmith(dot)com http://www.gregsmith.com Baltimore, MD

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Greg Smith 2007-06-27 05:14:08 Re: Bgwriter LRU cleaning: we've been going at this all wrong
Previous Message Greg Smith 2007-06-27 04:48:25 Re: Bgwriter LRU cleaning: we've been going at this all wrong