Re: Implementation Proposal For Add Free Behind - Mailing list pgsql-hackers

From Neil Padgett
Subject Re: Implementation Proposal For Add Free Behind
Date
Msg-id 1014673410.26119.4.camel@totally-bodacious
Whole thread Raw
In response to Implementation Proposal For Add Free Behind Capability For Large Sequential Scan  (Amit Kumar Khare <skamit2000@yahoo.com>)
Responses Re: Implementation Proposal For Add Free Behind Capability For Large Sequential Scan  (Amit Kumar Khare <skamit2000@yahoo.com>)
List pgsql-hackers
On Sat, 2002-02-23 at 08:30, Amit Kumar Khare wrote:

> Considering thesesuggestions as our baseline we have decided to
implement Most Recently Used(MRU) cache replacement policy. Our task
will be to identify a large sequentialscan and then advice the buffer
manager to apply MRU for cache replacement.

This could lead to poor buffer performance in the case of multiple
backends simultaneously executing queries. How will you handle this?

Neil

-- 
Neil Padgett
Red Hat Canada Ltd.                       E-Mail:  npadgett@redhat.com
2323 Yonge Street, Suite #300, 
Toronto, ON  M4P 2C9



pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: More time zones
Next
From: Tom Lane
Date:
Subject: Re: [GENERAL] Defunct postmasters