Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group