Re: PostgreSQL caching - Mailing list pgsql-performance

From Rod Taylor
Subject Re: PostgreSQL caching
Date
Msg-id 1085164433.20081.265.camel@jester
Whole thread Raw
In response to Re: PostgreSQL caching  (Chris Browne <cbbrowne@acm.org>)
List pgsql-performance
> What is essentially required is the "prescient cacheing algorithm,"
> where the postmaster must consult /dev/esp in order to get a
> prediction of what blocks it may need to refer to in the next sixty
> seconds.

Easy enough. Television does it all the time with live shows. The guy
with the buzzer always seems to know what will be said before they say
it. All we need is a 5 to 10 second delay...


pgsql-performance by date:

Previous
From: Chris Browne
Date:
Subject: Re: PostgreSQL caching
Next
From: Bill Montgomery
Date:
Subject: Avoiding vacuum full on an UPDATE-heavy table