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

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

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



In response to

Responses

pgsql-hackers by date

Next:From: Bernd HelmleDate: 2007-06-29 13:09:30
Subject: pg_dump and minor versions
Previous:From: Theo SchlossnagleDate: 2007-06-29 12:33:43
Subject: Re: [PATCHES] Doc update for pg_start_backup

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