Re: disk space usage enlarging despite vacuuming

Ron Snyder <snyder(at)roguewave(dot)com> writes:
>> What's your turnover rate for updating or deleting large objects?
> There's probably only about 10K additions/day, and there should be about
> 7500 deletions/day.

How large are the objects in question?

>> I'm guessing that you have the FSM parameters (in postgresql.conf) set
>> too small to allow the system to keep track of all the free space in
>> pg_largeobject.

> Doh! I meant to include this info, because I knew you'd want it.
> max_fsm_pages is 100K, and max_fsm_relations is left at the default (of
> 100).

100 is almost certainly too small for max_fsm_relations (we've changed
the default to 1000 as of 7.3.something). How many active databases do
you have, and how many user tables?

regards, tom lane