Re: TOAST tables keeps growing!

"Thomas Madsen" <tm(at)softcom(dot)dk> writes:
> What can I do to reclaim the wasted TOAST diskspace?

vacuum full might help.

> Can I find and eliminate the lost TOAST tuples somehow?

Well, one thing to ask is whether it's the toast *table* that's
bloating, or the *index* on the toast table. (VACUUM VERBOSE
would help you find out.)

If it's the table, then more frequent plain vacuums and/or increasing
FSM should fix it. If the index is growing while the table stays
about the same, you could try periodic REINDEXes, but the only real
solution is to move up to PG 7.4.

regards, tom lane