Re: db size growing out of control when using clustered Jackrabbit

From: Craig Ringer <ringerc(at)ringerc(dot)id(dot)au>
To: Gary Webster <webster(at)lexmark(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: db size growing out of control when using clustered Jackrabbit
Date: 2012-07-24 00:35:19
Message-ID: 500DEDC7.3000402@ringerc.id.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On 07/24/2012 05:13 AM, Gary Webster wrote:
> Hello. I'm hoping someone has seen this before.
>
> We are trying to use Postgres Plus v9.1.3 as the Persistence Manager
> in Jackrabbit (Apache JCR) clustering
> (http://wiki.apache.org/jackrabbit/Clustering).
> Whenever the JCR is under load, the ws_bundle TOAST table in the
> repository schema, grows out of control !

Has somebody disabled autovacuum or set it to barely run at all?

Try setting autovacuum to very aggressively vacuum the problem table(s).

--
Craig Ringer

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Gary Webster 2012-07-24 15:34:57 Re: db size growing out of control when using clustered Jackrabbit
Previous Message Joshua D. Drake 2012-07-23 21:40:11 Re: db size growing out of control when using clustered Jackrabbit