Re: Incorrect index being used

Поиск
Список
Период
Сортировка
От Albe Laurenz
Тема Re: Incorrect index being used
Дата
Msg-id A737B7A37273E048B164557ADEF4A58B17C2975B@ntex2010a.host.magwien.gv.at
обсуждение исходный текст
Ответ на Re: Incorrect index being used  (Jesse Long <jpl@unknown.za.net>)
Список pgsql-general
Jesse Long wrote:
> I did ALTER COLUMN SET STATISTICS 10000 for each column involved after
> that (is that what you meant?). But it did not make much difference, but
> I have read the manual regarding this setting and think I understand it.
> 
> Would it be a bad idea to ALTER COLUMN SET STATISTICS 100000? Would that
> have a very negative impact on disk usage or performace?

No, in the light of what Tom wrote, I was on the wrong track entirely
and your best bet is probably to rewrite the query.

Yours,
Laurenz Albe

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

Предыдущее
От: Víctor Cosqui
Дата:
Сообщение: Re: Doubt with physical storage being used by postgres when storing LOBs
Следующее
От: hiroyuki shiga
Дата:
Сообщение: Re: postgresql9.1.6 core dump