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)  (Edmund Dengler <edmundd@eSentire.com>)
Список 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 по дате отправления:

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: Slow Inserts on 1 table?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: feeding big script to psql