Jeffrey W. Baker wrote:
> On Mon, 2002-03-11 at 13:30, Jan Wieck wrote:
>
> > The best cure for a problem is avoiding it. I would suggest
> > running the light weight VACUUM more often, so that it
> > doesn't grow that big in the first place.
>
> I think everybody is missing my point. This entire database is vacuumed
> every HOUR. All the tables are reasonably sized, and they stay that
> way. Except, the magic pg_toast table where long objects from resp_body
> are store is growing and growing and growing and growing and does not
> seem to respond to VACUUM whatsoever.
You actually did a VACUUM FULL and it didn't shrink? In 7.2
no table does shrink on a normal VACUUM. So if you don't run
VACUUM FULL, it cannot!
Jan
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck@Yahoo.com #
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com