| From: | Jeison Bedoya <jeisonb(at)audifarma(dot)com(dot)co> |
|---|---|
| To: | "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
| Subject: | to many locks held |
| Date: | 2013-07-30 10:52:28 |
| Message-ID: | 51F79AEC.3070103@audifarma.com.co |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | bricklen | 2013-07-30 14:48:08 | Re: to many locks held |
| Previous Message | Stefan Keller | 2013-07-29 23:29:46 | Re: FTS performance issue - planner problem identified (but only partially resolved) |