Bruno Wolff III <bruno@wolff.to> writes:
> On Sat, Jun 14, 2003 at 18:57:42 +1000,
> Jason Godden <jasongodden@optushome.com.au> wrote:
>> My mistake - even though I was running VACUUM everyday I wasn't running VACUUM
>> FULL - a VACUUM FULL fixed the problem. Strange - I thought that regular
>> VACUUM was pretty good these days?
> You need to make sure that FSM is set high enough
The default FSM settings are good for a database of up to maybe 100mb
or so. For your 2Gb database you probably need to ratchet max_fsm_pages
up by about a factor of 10, and make sure that max_fsm_relations is big
enough for all your tables too.
regards, tom lane