Re: LRU and full table scans

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: LRU and full table scans
Дата
Msg-id 200203131827.g2DIRXi22518@candle.pha.pa.us
обсуждение исходный текст
Ответ на Re: LRU and full table scans  ("Roque Bonilla" <roque.bonilla@wanadoo.es>)
Список pgsql-hackers
Roque Bonilla wrote:
> First Hello, Second...Yes, I'm doing some studies on the buffer manager and
> also studying and implementing different policys, one of them is the LRU-K.
> 
> By the time I don't have any results, I'm just preparing to run the TPC-H
> benchmark to test all the policys that I have implemented.
> I have implemented some policys for the buffer manager, some better and some
> worst than LRU (FIFO, LFU, LRD, FBR, LRU-K, LRFU, 4 CLOCK policys (or second
> chance), CORRELATED REFERENCES, and different combinations of them like
> (LFU+CLOCK+AGING(by division or by substraction)+CORRELATED REFERENCES)),
> there are seven principal policys and seven "add-on's" that could be applyed
> to them, resulting in 25 combinations of policys.

We do have someone working on LRU-K but we haven't seen any test results
from him yet.  Please let us know what you find.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Luis Alberto Amigo Navarro"
Дата:
Сообщение: Re: again on bad performance
Следующее
От: missive@frontiernet.net (Lee Harr)
Дата:
Сообщение: Re: bug in psql