Re: LRU and full table scans - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: LRU and full table scans
Date
Msg-id 200203131827.g2DIRXi22518@candle.pha.pa.us
Whole thread Raw
In response to Re: LRU and full table scans  ("Roque Bonilla" <roque.bonilla@wanadoo.es>)
List 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 by date:

Previous
From: "Luis Alberto Amigo Navarro"
Date:
Subject: Re: again on bad performance
Next
From: missive@frontiernet.net (Lee Harr)
Date:
Subject: Re: bug in psql