Re: pg_toast table growth out of control

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