On Wed, Aug 20, 2003 at 05:21:35PM -0400, Jan Wieck wrote:
> What about a little hint to the buffer management that if it has to
> evict another buffer to physically read this one (meaning the buffer
> pool was full already) then it will not put this buffer at the top of
> the LRU chain but rather at it's end? This way a vacuum on a large table
> will not cause a complete cache eviction.
>
> Might be a useful hint for sequential scans too.
Somebody was playing with using LRU-2 or ARC or some other algorithm for
page replacement instead of the current LRU... wouldn't it help with
this too?
--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"La vida es para el que se aventura"