Re: Buglist

Alvaro Herrera <alvherre@dcc.uchile.cl>

From: Alvaro Herrera <alvherre@dcc.uchile.cl>
To: Jan Wieck <JanWieck@Yahoo.com>
Cc: Andrew Sullivan <andrew@libertyrms.info>, pgsql-general@postgresql.org
Date: 2003-08-21T01:29:08Z
Lists: pgsql-hackers, pgsql-general
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"