2Q implementaion for PostgreSQL buffer replacement. - Mailing list pgsql-hackers

From Yutaka tanida
Subject 2Q implementaion for PostgreSQL buffer replacement.
Date
Msg-id 20030623144157.B16C.YUTAKA@nonsensecorner.com
Whole thread Raw
Responses Re: 2Q implementaion for PostgreSQL buffer replacement.  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: 2Q implementaion for PostgreSQL buffer replacement.  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
Hi.

I implement 2Q algorithm to PostgreSQL for buffer management , instead
of LRU.
It's known as low overhead and high performance than LRU. If you have
some interests , see following URL.

http://www.vldb.org/conf/1994/P439.PDF

In my test (pgbench -S) , it improves 4% cache hit rate and 2% up
performance comparing from LRU.

Do you have any interest about this patch?

--
Yutaka tanida <yutaka@nonsensecorner.com>
http://www.nonsensecorner.com/

Attachment

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Two weeks to feature freeze
Next
From: Sailesh Krishnamurthy
Date:
Subject: Re: Two weeks to feature freeze