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

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

From: Gary Webster <webster(at)lexmark(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Cc: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
Subject: Re: db size growing out of control when using clustered Jackrabbit
Date: 2012-07-25 18:37:18
Message-ID: CAEHjwJ4qf2emMPKadyEkXyFVBbeMBNKjNo0ssTPfVGbxXfRazw@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
On Tue, Jul 24, 2012 at 1:41 PM, Joshua D. Drake <jd(at)commandprompt(dot)com>wrote:

>
> 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.
>

OK, how do I track/debug/stop the "idle in transaction"s ?


>  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.
>
> I was hoping to find more of a 'root cause' (eg. jackrabbit config) for
this issue.
I can't believe that this table is supposed to be getting so big, to even
require much vacuuming.

>
>
>  Autovacuum does appear to usually get 'auto-canceled' by a lock.
>>
>
> That is a problem too.
>
> OK, I am trying to find out why this is happening.


>  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
>

In response to

Responses

pgsql-admin by date

Next:From: Joshua D. DrakeDate: 2012-07-25 18:44:44
Subject: Re: db size growing out of control when using clustered Jackrabbit
Previous:From: Joshua D. DrakeDate: 2012-07-25 18:15:50
Subject: Re: Could You help me

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