Re: index vs. seq scan choice?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: index vs. seq scan choice?
Дата
Msg-id 115.1180063568@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: index vs. seq scan choice?  ("Joshua D. Drake" <jd@commandprompt.com>)
Ответы Re: index vs. seq scan choice?  (Steve Atkins <steve@blighty.com>)
Список pgsql-general
"Joshua D. Drake" <jd@commandprompt.com> writes:
> Tom Lane wrote:
>> I'm not sure I want to vote for another 10x increase by
>> default, though.

> Outside of longer analyze times, and slightly more space taken up by the
> statistics, what is the downside?

Longer plan times --- several of the selfuncs.c routines grovel over all
the entries in the pg_statistic row.  AFAIK no one's measured the real
impact of that, but it could easily be counterproductive for simple queries.

            regards, tom lane

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

Предыдущее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: index vs. seq scan choice?
Следующее
От: Steve Atkins
Дата:
Сообщение: Re: index vs. seq scan choice?