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"