Re: Planner selects different execution plans depending on limit

Поиск
Список
Период
Сортировка
От Bill Martin
Тема Re: Planner selects different execution plans depending on limit
Дата
Msg-id D48BF41C96B16442B542F5E25C259047011E80F02A@COM211.communardo.local
обсуждение исходный текст
Ответы Re: Planner selects different execution plans depending on limit  (Jesper Krogh <jesper@krogh.cc>)
Список pgsql-performance
> Tom Lane <tgl@sss.pgh.pa.us> writes:
>> Bill Martin <bill.martin@communote.com> writes:
>> I've tried different values for the statistics but it is all the same (the planner decide to switch to a seqscan if
thelimit is 10).
 

>> ALTER TABLE core_content ALTER column content SET STATISTICS 1000;

> Um, did you actually do an ANALYZE after changing that?
> 
>             regards, tom lane

Yes, I've run the ANALYZE command.

Regards,
Bill Martin

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Planner selects different execution plans depending on limit
Следующее
От: Jesper Krogh
Дата:
Сообщение: Re: Planner selects different execution plans depending on limit