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.
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
