Re: Implementation Proposal For Add Free Behind Capability For Large Sequential Scan

--- Neil Padgett <npadgett@redhat.com> wrote:
> 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.
Neil wrote:
> This could lead to poor buffer performance in the
> case of multiple
> backends simultaneously executing queries. How will
> you handle this?

Certainly it's cause of concern. I am looking for
literature regarding it. I kindly request you all to
inform me if any body finds some thing related to it.

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


__________________________________________________
Do You Yahoo!?
Yahoo! Sports - Coverage of the 2002 Olympic Games
http://sports.yahoo.com