Re: seq scan cache vs. index cache smackdown

Поиск
Список
Период
Сортировка
От Iain
Тема Re: seq scan cache vs. index cache smackdown
Дата
Msg-id 001e01c5132b$48efbe40$7201a8c0@mst1x5r347kymb
обсуждение исходный текст
Ответ на seq scan cache vs. index cache smackdown  (Mark Aufflick <mark@pumptheory.com>)
Список pgsql-performance
Hi Rod,

> Any solution fixing buffers should probably not take into consideration
> the method being performed (do you really want to skip caching a
> sequential scan of a 2 tuple table because it didn't use an index) but
> the volume of data involved as compared to the size of the cache.

Yes, in fact indexes aren't so different to tables really in that regard.

It sounds like version 8 may help out anyway.

regards
Iain

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

Предыдущее
От: "Iain"
Дата:
Сообщение: Re: VACCUM FULL ANALYZE PROBLEM
Следующее
От: Greg Stark
Дата:
Сообщение: Re: seq scan cache vs. index cache smackdown