From: Joshua D. Drake <jd@commandprompt.com>
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 10:41:41 -0700
Message-ID: <500EDE55.9060409@commandprompt.com> (raw)
In-Reply-To: <CAEHjwJ75MB1jm0W516w1YJt7NJ35a=pHaPPtMf1z+SX=G+9qLA@mail.gmail.com>
References: <CAEHjwJ6pu1D+nQEbdg=bimY0gKVFvBTVq6JoMQjt3v3_ChMncA@mail.gmail.com>
<500DC4BB.2090102@commandprompt.com>
<CAEHjwJ75MB1jm0W516w1YJt7NJ35a=pHaPPtMf1z+SX=G+9qLA@mail.gmail.com>
On 07/24/2012 08:58 AM, Gary Webster wrote:
> Hello.
> Thanks for the response.
>
> There are several 'idle in transaction' on this server/app, but to a
> different db/schema.
This is a cluster issue, not a database issue. So if you have an idnle
in transaction, then it is affecting your JCR schema as well.
> The "repository" (JCR) schema has only a few 'idle', none 'in transaction' .
>
> By "routine maintenance", do you mean autovacuum, or something else?
I mean autovacuum.
> Autovacuum does appear to usually get 'auto-canceled' by a lock.
That is a problem too.
> However, even when it runs successfully, it doesn't seem to help with
> this ws_bundle Toast table size.
It won't if you have the above idle in transactions, regardless of database.
Sincerely,
jD
--
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Support, Training, Professional Services and Development
High Availability, Oracle Conversion, Postgres-XC
@cmdpromptinc - 509-416-6579
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: jd@commandprompt.com, webster@lexmark.com
Subject: Re: db size growing out of control when using clustered Jackrabbit
In-Reply-To: <500EDE55.9060409@commandprompt.com>
* 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