Re: Query times change by orders of magnitude as DB ages

Поиск
Список
Период
Сортировка
От Sergey Aleynikov
Тема Re: Query times change by orders of magnitude as DB ages
Дата
Msg-id a233edb60911260436k653a29aex5cb353f2b6c6cf6@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Query times change by orders of magnitude as DB ages  (Richard Neill <rn214@cam.ac.uk>)
Ответы Re: Query times change by orders of magnitude as DB ages  (Richard Neill <rn214@cam.ac.uk>)
Список pgsql-performance
Дерево обсуждения 
Hello,

2009/11/25 Richard Neill <rn214@cam.ac.uk>:

Also, if you find odd statistics of freshly analyzed table - try
increasing statistics target, using
ALTER TABLE .. ALTER COLUMN .. SET STATISTICS ...

If you're using defaults - it's again low for large tables. Start with
200, for example.

Best regards,
Sergey Aleynikov

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

Предыдущее
От: Sergey Aleynikov
Дата:
Сообщение: Re: Query times change by orders of magnitude as DB ages
Следующее
От: Richard Neill
Дата:
Сообщение: Re: Query times change by orders of magnitude as DB ages