Re: Bgwriter LRU cleaning: we've been going at this all wrong - Mailing list pgsql-hackers

From Greg Smith
Subject Re: Bgwriter LRU cleaning: we've been going at this all wrong
Date
Msg-id Pine.GSO.4.64.0706270049000.10954@westnet.com
Whole thread Raw
In response to Re: Bgwriter LRU cleaning: we've been going at this all wrong  (ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp>)
Responses Re: Bgwriter LRU cleaning: we've been going at this all wrong
List 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@gregsmith.com http://www.gregsmith.com Baltimore, MD


pgsql-hackers by date:

Previous
From: Greg Smith
Date:
Subject: Re: Bgwriter LRU cleaning: we've been going at this all wrong
Next
From: Greg Smith
Date:
Subject: Re: Bgwriter LRU cleaning: we've been going at this all wrong