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

Поиск
Список
Период
Сортировка
От Amit Kumar Khare
Тема Re: Implementation Proposal For Add Free Behind Capability For Large Sequential Scan
Дата
Msg-id 20020226173032.31730.qmail@web10106.mail.yahoo.com
обсуждение исходный текст
Ответ на Re: Implementation Proposal For Add Free Behind  (Neil Padgett <npadgett@redhat.com>)
Ответы Re: Implementation Proposal For Add Free Behind Capability  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-hackers
--- 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


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Thomas Lockhart
Дата:
Сообщение: Re: PostgreSQL 8.0 ??
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Implementation Proposal For Add Free Behind Capability