Re: Calculation for Max_FSM_pages : Any rules of thumb?

Поиск
Список
Период
Сортировка
От Ow Mun Heng
Тема Re: Calculation for Max_FSM_pages : Any rules of thumb?
Дата
Msg-id 1194935844.8717.19.camel@neuromancer.home.net
обсуждение исходный текст
Ответ на Re: Calculation for Max_FSM_pages : Any rules of thumb?  (Bill Moran <wmoran@potentialtech.com>)
Ответы Re: Calculation for Max_FSM_pages : Any rules of thumb?
Список pgsql-general
On Thu, 2007-11-08 at 12:02 -0500, Bill Moran wrote:
> Frequently, when people ask for help because they've exceed max_fsm*,
> it's because they're not paying attention to their systems, and therefore
> the problem has been occurring for a while before it got so bad that
> they couldn't ignore it.  As a result, a full vacuum is frequently a
> necessity.
>
> Folks who are monitoring their databases closely don't hit this
> problem nearly as often.
>

How does one monitor it closely anyway? the warning comes when one does
a vacuum verbose and with autovacuum turned on, I don't even see it
anywhere.



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

Предыдущее
От: "Albe Laurenz"
Дата:
Сообщение: Re: Accessing a db with pgAdmin
Следующее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: PQexec(), what should I do for the "NULL in command" problem?