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.