Re: Vacuum and FSM page size

On Jan 23, 2008, at 1:29 PM, Thomas Lozza wrote:

> We have an installation of Postgres 8.1.2 (32bit on Solaris 9) with  
> a DB
> size of about 250GB on disk. The DB is subject to fair amount of
> inserts, deletes and updates per day.
>
> Running VACUUM VERBOSE tells me that I should allocate around 20M  
> pages
> to FSM (max_fsm_pages)! This looks like a really large amount to me.
>
> Has anyone gone ever that high with max_fsm_pages?

wow.  you must have a *lot* of pages with empty space in them....

it sounds to me like your autovacuum is not running frequently enough.