Ron Snyder <snyder@roguewave.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