Re: Ответ: [HACKERS] Possible performance improvement: buffer replacement policy - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Ответ: [HACKERS] Possible performance improvement: buffer replacement policy
Date
Msg-id 26573.971715200@sss.pgh.pa.us
Whole thread Raw
In response to Ответ: [HACKERS] Possible performance improvement: buffer replacement policy  ("Mikheev, Vadim" <vmikheev@SECTORBASE.COM>)
List pgsql-hackers
"Mikheev, Vadim" <vmikheev@SECTORBASE.COM> writes:
> Excuse me but what is LRU-2?

Like LRU, but using time to second most recent reference, instead of
most recent reference, to sort the buffers for recycling.  This gives
a more robust statistic about how often the page is actually being
touched.  (Or that's the theory anyway.)

> I know that in Oracle unused buffers are not in
> simple LRU list: Oracle tries to postpone writes
> as long as possible -:)

Manage dirty buffers separately from clean ones, you mean?  Hm, we could
do that.  With WAL it might even make sense, though before we tended to
flush dirty buffers so fast it would hardly matter.

            regards, tom lane


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Full text indexing (Question/request)
Next
From: Bruce Momjian
Date:
Subject: Re: Yet another LIKE-indexing scheme