Re: How to improve postgres performace

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: How to improve postgres performace
Дата
Msg-id 22280.1113839890@sss.pgh.pa.us
обсуждение исходный текст
Ответ на How to improve postgres performace  ("Rodrigo Moreno" <rodrigo.miguel@terra.com.br>)
Ответы RES: How to improve postgres performace  ("Rodrigo Moreno" <rodrigo.miguel@terra.com.br>)
Список pgsql-performance
"Rodrigo Moreno" <rodrigo.miguel@terra.com.br> writes:
> At this weekend i have started to use pg_autovacuum with default settings.

> I really worried about that, because it's no enough anymore, and users claim
> about performace. But running the vacuumdb full, everthing starts to run
> better again, so i think the problem is not related to a specific query.

It sounds like you may not have the FSM settings set large enough for
your database.  The default settings are only enough for a small DB
(perhaps a few hundred meg).

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: immutable functions vs. join for lookups ?
Следующее
От: Andrei Gaspar
Дата:
Сообщение: Re: Sort and index