to many locks held
От | Jeison Bedoya |
---|---|
Тема | to many locks held |
Дата | |
Msg-id | 51F79AEC.3070103@audifarma.com.co обсуждение исходный текст |
Ответы |
Re: to many locks held
Re: to many locks held |
Список | 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
В списке pgsql-performance по дате отправления: