Re: Failure to use indexes (fwd)

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: Failure to use indexes (fwd)
Дата
Msg-id 1123017729.21793.46.camel@state.g2switchworks.com
обсуждение исходный текст
Ответ на Re: Failure to use indexes (fwd)  (Dr NoName <spamacct11@yahoo.com>)
Ответы Re: Failure to use indexes (fwd)
Список pgsql-general
On Tue, 2005-08-02 at 16:06, Dr NoName wrote:
> The solution to my problem was to increase statistics
> value and do another analyze. You can also change
> default_statistics_target parameter in
> postgresql.conf. Don't know if that's related to the
> problem you're seeing, but it's worth a try.

Cool postgresql trick:

alter database test set default_statistics_target=200;

You can change the default for a databases's new tables too.

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