Re: help speeding up a query in postgres 8.4.5

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: help speeding up a query in postgres 8.4.5
Дата
Msg-id 4D9C4182020000250003C3AB@gw.wicourts.gov
обсуждение исходный текст
Ответ на Re: help speeding up a query in postgres 8.4.5  ("Maria L. Wilson" <Maria.L.Wilson-1@nasa.gov>)
Ответы Re: help speeding up a query in postgres 8.4.5  (Tomas Vondra <tv@fuzzy.cz>)
Re: help speeding up a query in postgres 8.4.5  ("Maria L. Wilson" <Maria.L.Wilson-1@nasa.gov>)
Список pgsql-performance
"Maria L. Wilson" <Maria.L.Wilson-1@nasa.gov> wrote:

> Autovacuum is not running - but regular vacuums are being done
> twice daily.

Is the ANALYZE keyword used on those VACUUM runs?  What version of
PostgreSQL is this.  If it's enough to need fsm settings, do you run
with the VERBOSE option and check the end of the output to make sure
they are set high enough?

-Kevin

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

Предыдущее
От: "Maria L. Wilson"
Дата:
Сообщение: Re: help speeding up a query in postgres 8.4.5
Следующее
От: Tomas Vondra
Дата:
Сообщение: Re: help speeding up a query in postgres 8.4.5