Re: pg_toast table growth out of control - Mailing list pgsql-general

From Jeffrey W. Baker
Subject Re: pg_toast table growth out of control
Date
Msg-id 1015882729.31887.20.camel@heat
Whole thread Raw
In response to Re: pg_toast table growth out of control  (Jan Wieck <janwieck@yahoo.com>)
Responses Re: pg_toast table growth out of control  (Jan Wieck <janwieck@yahoo.com>)
List pgsql-general
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.

-jwb


pgsql-general by date:

Previous
From: Jan Wieck
Date:
Subject: Re: pg_toast table growth out of control
Next
From: "Booth, Robert"
Date:
Subject: fmgr_info: function 0: cache lookup failed