Re: help speeding up a query in postgres 8.4.5

Поиск
Список
Период
Сортировка
От Maria L. Wilson
Тема Re: help speeding up a query in postgres 8.4.5
Дата
Msg-id 4D9C88B8.6000205@nasa.gov
обсуждение исходный текст
Ответ на Re: help speeding up a query in postgres 8.4.5  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Список pgsql-performance
yep - we use analyze and check the output.  It's version 8.4.5 so no fsm
issues.

thanks,  Maria

On 4/6/11 11:33 AM, Kevin Grittner wrote:
> "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 по дате отправления:

Предыдущее
От: Thom Brown
Дата:
Сообщение: Re: Partial index slower than regular index
Следующее
От: Thom Brown
Дата:
Сообщение: Re: Partial index slower than regular index