free space map settings

From: Joseph Shraibman <jks(at)selectacast(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: free space map settings
Date: 2005-07-18 17:33:00
Message-ID: 42DBE7CC.7090706@selectacast.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

INFO: free space map: 195 relations, 96448 pages stored; 417104 total
pages needed
DETAIL: Allocated FSM size: 1000 relations + 90000 pages = 588 kB
shared memory.

I'm confused, do I need to set my fsm settings to 96448 or 417104 based
on this output?

Are fsm settings updated during a vacuum on a table? I have a heavily
updated table that I vacuum every 10 minutes, but I still don't seem to
be running out of room in the fsm.

Browse pgsql-general by date

  From Date Subject
Next Message Akash Garg 2005-07-18 17:35:40 Re: Error while vacuuming
Previous Message Lincoln Yeoh 2005-07-18 17:32:30 Re: Converting MySQL tinyint to PostgreSQL