| From: | Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl> |
|---|---|
| To: | Jan Wieck <JanWieck(at)Yahoo(dot)com> |
| Cc: | Andrew Sullivan <andrew(at)libertyrms(dot)info>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Buglist |
| Date: | 2003-08-21 01:29:08 |
| Message-ID: | 20030821012908.GA4974@dcc.uchile.cl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
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"
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christopher Kings-Lynne | 2003-08-21 01:42:45 | Re: Need concrete "Why Postgres not MySQL" bullet list |
| Previous Message | Greg Stark | 2003-08-21 00:19:35 | Re: Collation rules and multi-lingual databases |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christopher Kings-Lynne | 2003-08-21 01:42:45 | Re: Need concrete "Why Postgres not MySQL" bullet list |
| Previous Message | wade | 2003-08-20 23:09:08 | unsubscribe |