From: Jeison Bedoya <jeisonb@audifarma.com.co>
To: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: to many locks held
Date: Tue, 30 Jul 2013 05:52:28 -0500
Message-ID: <51F79AEC.3070103@audifarma.com.co> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
Hi everybody,
In recent days, we have seen many processes in reaching the lock held
5000. At that time my machine will become sluggish and no response from
the database. I tried to change configuration parameters, but have not
found anything satisfactory. further in meeting log messages like the
following:
COTidleERROR: out of memory
COTidleDETAIL: Can not enlarge string buffer container containing 0
bytes by 1476395004 more bytes.
COTidleLOG: incomplete message from client
COTUPDATE waitingLOG: process 20761 still waiting for ShareLock on
transaction 10,580,510 1664,674 ms after
My machine is on linux postgres version 9.2.2, and the following settings:
memory ram: 128 GB
cores: 32
max_connections: 900
shared_buffers = 2048MB
work_mem = 1024MB
maintenance_work_mem = 1024MB
temp_buffers = 512MB
checkpoint_segments = 103
regrads
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
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-performance@postgresql.org
Cc: jeisonb@audifarma.com.co
Subject: Re: to many locks held
In-Reply-To: <51F79AEC.3070103@audifarma.com.co>
* 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