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

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Gary Webster <webster(at)lexmark(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org, "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
Subject: Re: db size growing out of control when using clustered Jackrabbit
Date: 2012-07-26 20:05:19
Message-ID: CAOR=d=3AJ4GXn8+_E_VrNxyNzqE8_8a4Nt6taexT2ZHuV6FZJQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Thu, Jul 26, 2012 at 1:31 PM, Gary Webster <webster(at)lexmark(dot)com> wrote:
> OK, I set "log_statement = "all""
> The log grew to 1GB in ~minute! It is dominated by this one statement,
> which occurs every ~1.4 sec:
> "update WS_BUNDLE set BUNDLE_DATA = $1 where NODE_ID_HI = $2 and NODE_ID_LO
> = $3"
> parameter $1 is hex, over 6million characters long !! Surely this is the
> root of my problem.

That's crazy big. Is that a normal payload size for this app?

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Alanoly Andrews 2012-07-27 15:49:44 pg_dump on Postgres 9.1
Previous Message Gary Webster 2012-07-26 19:31:48 Re: db size growing out of control when using clustered Jackrabbit