Re: pg_toast table growth out of control

From: "Jeffrey W(dot) Baker" <jwb(at)saturn5(dot)com>
To: Jan Wieck <janwieck(at)yahoo(dot)com>
Cc: John Gray <jgray(at)azuli(dot)co(dot)uk>, Postgres general mailing list <pgsql-general(at)postgresql(dot)org>
Subject: Re: pg_toast table growth out of control
Date: 2002-03-11 21:38:49
Message-ID: 1015882729.31887.20.camel@heat
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Booth, Robert 2002-03-11 21:40:56 fmgr_info: function 0: cache lookup failed
Previous Message Bruce Momjian 2002-03-11 21:33:37 Re: using syslog to capture RAISE notices