Re: planner/optimizer question

Поиск
Список
Период
Сортировка
От Gary Doades
Тема Re: planner/optimizer question
Дата
Msg-id 40917CDC.3078.14EE7897@localhost
обсуждение исходный текст
Ответ на Re: planner/optimizer question  ("Gary Doades" <gpd@gpdnet.co.uk>)
Список pgsql-performance
On 29 Apr 2004 at 15:35, Kenneth Marshall wrote:

> Did you try to cluster based on the index?
>
> --Ken

Yes, This speeds up the index scan a little (12%). This to me just
reinforces the overhead that subsequently having to go and fetch the
data tuple actually has on the performance.

Cheers,
Gary.


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

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: planner/optimizer question
Следующее
От: Vitaly Belman
Дата:
Сообщение: Re: Simply join in PostrgeSQL takes too long