, 2008 10:48
To: Thomas Lozza
Cc: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] Vacuum and FSM page size
On Jan 23, 2008 12:29 PM, Thomas Lozza <[EMAIL PROTECTED]>
wrote:
> Auto vacuum is enabled. Here are the settings:
>
> autovacuum = true
> autova
hi
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 rea
