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

--- Neil Padgett <npadgett(at)redhat(dot)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(at)redhat(dot)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