From: Craig Ringer <ringerc@ringerc.id.au>
To: Gary Webster <webster@lexmark.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: db size growing out of control when using clustered Jackrabbit
Date: Tue, 24 Jul 2012 08:35:19 +0800
Message-ID: <500DEDC7.3000402@ringerc.id.au> (raw)
In-Reply-To: <CAEHjwJ6pu1D+nQEbdg=bimY0gKVFvBTVq6JoMQjt3v3_ChMncA@mail.gmail.com>
References: <CAEHjwJ6pu1D+nQEbdg=bimY0gKVFvBTVq6JoMQjt3v3_ChMncA@mail.gmail.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: ringerc@ringerc.id.au, webster@lexmark.com
Subject: Re: db size growing out of control when using clustered Jackrabbit
In-Reply-To: <500DEDC7.3000402@ringerc.id.au>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox