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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
