Re: index scan of whole table, can't see why

Поиск
Список
Период
Сортировка
От Ragnar Hafstað
Тема Re: index scan of whole table, can't see why
Дата
Msg-id 1106213038.22416.10.camel@localhost.localdomain
обсуждение исходный текст
Ответ на Re: index scan of whole table, can't see why  (andrew@pillette.com)
Список pgsql-performance
On Wed, 2005-01-19 at 21:00 -0800, andrew@pillette.com wrote:
> Let's see if I have been paying enough attention to the SQL gurus.
> The planner is making a different estimate of how many deprecated<>'' versus how many broken <> ''.
> I would try SET STATISTICS to a larger number on the ports table, and re-analyze.

that should not help, as the estimate is accurate, according to the
explain analyze.

gnari



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

Предыдущее
От: William Yu
Дата:
Сообщение: Re: Tips and tunning for pgsql on HP-UX PA-RISC (RP3410)
Следующее
От: Ragnar Hafstað
Дата:
Сообщение: Re: index scan of whole table, can't see why