Re: Calculation for Max_FSM_pages : Any rules of thumb? - Mailing list pgsql-general

From Ow Mun Heng
Subject Re: Calculation for Max_FSM_pages : Any rules of thumb?
Date
Msg-id 1194935844.8717.19.camel@neuromancer.home.net
Whole thread Raw
In response to Re: Calculation for Max_FSM_pages : Any rules of thumb?  (Bill Moran <wmoran@potentialtech.com>)
Responses Re: Calculation for Max_FSM_pages : Any rules of thumb?  (Bill Moran <wmoran@potentialtech.com>)
List 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 by date:

Previous
From: "Albe Laurenz"
Date:
Subject: Re: Accessing a db with pgAdmin
Next
From: Martijn van Oosterhout
Date:
Subject: Re: PQexec(), what should I do for the "NULL in command" problem?