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

Поиск
Список
Период
Сортировка
Искать
От
Greg Smith
Тема
Re: Bgwriter LRU cleaning: we've been going at this all wrong
Дата
Msg-id
Pine.GSO.4.64.0706270049000.10954@westnet.com
Ответ на
Список
Дерево обсуждения
Bgwriter LRU cleaning: we've been going at this all wrong Tom Lane <tgl@sss.pgh.pa.us>
Re: Bgwriter LRU cleaning: we've been going at this all wrong Heikki Linnakangas <heikki@enterprisedb.com>
Re: Bgwriter LRU cleaning: we've been going at this all wrong ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp>
Re: Bgwriter LRU cleaning: we've been going at this all wrong Greg Smith <gsmith@gregsmith.com>
Re: Bgwriter LRU cleaning: we've been going at this all wrong Jim Nasby <decibel@decibel.org>
Re: Bgwriter LRU cleaning: we've been going at this all wrong Greg Smith <gsmith@gregsmith.com>
Re: Bgwriter LRU cleaning: we've been going at this all wrong Greg Smith <gsmith@gregsmith.com>
Re: Bgwriter LRU cleaning: we've been going at this all wrong Tom Lane <tgl@sss.pgh.pa.us>
Re: Bgwriter LRU cleaning: we've been going at this all wrong Gregory Stark <stark@enterprisedb.com>
Re: Bgwriter LRU cleaning: we've been going at this all wrong Tom Lane <tgl@sss.pgh.pa.us>
Re: Bgwriter LRU cleaning: we've been going at this all wrong Bruce Momjian <bruce@momjian.us>
Re: Bgwriter LRU cleaning: we've been going at this all wrong Bruce Momjian <bruce@momjian.us>
Re: Bgwriter LRU cleaning: we've been going at this all wrong Gregory Stark <stark@enterprisedb.com>
Re: Bgwriter LRU cleaning: we've been going at this all wrong Greg Smith <gsmith@gregsmith.com>
Re: Bgwriter LRU cleaning: we've been going at this all wrong ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp>
Re: Bgwriter LRU cleaning: we've been going at this all wrong Greg Smith <gsmith@gregsmith.com>
Re: Bgwriter LRU cleaning: we've been going at this all wrong Jim Nasby <decibel@decibel.org>
Re: Bgwriter LRU cleaning: we've been going at this all wrong Gregory Stark <stark@enterprisedb.com>
Re: Bgwriter LRU cleaning: we've been going at this all wrong Greg Smith <gsmith@gregsmith.com>
Re: Bgwriter LRU cleaning: we've been going at this all wrong Heikki Linnakangas <heikki@enterprisedb.com>
Re: Bgwriter LRU cleaning: we've been going at this all wrong Greg Smith <gsmith@gregsmith.com>
Re: Bgwriter LRU cleaning: we've been going at this all wrong Tom Lane <tgl@sss.pgh.pa.us>
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 по дате отправления
От: Greg Smith
Дата:
От: Greg Smith
Дата:
FAQ