Re: pg_toast table growth out of control

"Jeffrey W. Baker" <jwb@saturn5.com> writes:
>> How big is the freespace map anyway, could this be an example
>> for that this table needs to be vacuumed even more often than
>> once per hour, Tom?

> I don't know how to tell.

I think what Jan was suggesting was increasing the default freespace
map size parameters (see postgresql.conf) to see if that makes any
difference.  I'm not sure if it will, but it'd be worth trying.
Note you will need a postmaster restart after editing postgresql.conf.
These are the relevant items:

#max_fsm_relations = 100    # min 10, fsm is free space map
#max_fsm_pages = 10000        # min 1000, fsm is free space map

            regards, tom lane