pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
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: Fri, 27 Jul 2012 11:11:34 -0700
Message-ID: <5012D9D6.8080002@commandprompt.com> (raw)
In-Reply-To: <CAEHjwJ44sJqAGpZeZZX+h=xLWw3Pi94AveX2DcNH3qEci=7eBA@mail.gmail.com>
References: <CAEHjwJ6pu1D+nQEbdg=bimY0gKVFvBTVq6JoMQjt3v3_ChMncA@mail.gmail.com>
	<500DC4BB.2090102@commandprompt.com>
	<CAEHjwJ75MB1jm0W516w1YJt7NJ35a=pHaPPtMf1z+SX=G+9qLA@mail.gmail.com>
	<500EDE55.9060409@commandprompt.com>
	<CAEHjwJ4qf2emMPKadyEkXyFVBbeMBNKjNo0ssTPfVGbxXfRazw@mail.gmail.com>
	<50103E9C.2050301@commandprompt.com>
	<CAEHjwJ44sJqAGpZeZZX+h=xLWw3Pi94AveX2DcNH3qEci=7eBA@mail.gmail.com>


On 07/26/2012 12:31 PM, Gary Webster 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.

It definitely is. Every time you update, you are creating a dead tuple 
(unless it is HOT capable). If autovacuum can't come in behind and clean 
that up due to idle in transaction, you are going to have serious problems.

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



view thread (12+ messages)

Message-ID: <5012D9D6.8080002@commandprompt.com>
Permalink:  ../5012D9D6.8080002@commandprompt.com/
Also on:    postgresql.org/message-id/5012D9D6.8080002@commandprompt.com

 · 

reply
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: <5012D9D6.8080002@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