Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group