Postgres Pro
Downloads
Home   >   mailing lists

Re: db size growing out of control when using clustered Jackrabbit - Mailing list pgsql-admin

From Craig Ringer
Subject Re: db size growing out of control when using clustered Jackrabbit
Date
Msg-id 500DEDC7.3000402@ringerc.id.au
Whole thread Raw
In response to db size growing out of control when using clustered Jackrabbit  (Gary Webster <webster@lexmark.com>)
Responses Re: db size growing out of control when using clustered Jackrabbit  (Gary Webster <webster@lexmark.com>)
List pgsql-admin
Tree view
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

pgsql-admin by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: db size growing out of control when using clustered Jackrabbit
Next
From: Gary Webster
Date:
Subject: Re: db size growing out of control when using clustered Jackrabbit