Re: [PERFORM] to many locks held

2013-07-30 Thread Michael Paquier
On Tue, Jul 30, 2013 at 11:48 PM, bricklen wrote: > On Tue, Jul 30, 2013 at 3:52 AM, Jeison Bedoya > wrote: > memory ram: 128 GB >> cores: 32 >> >> max_connections: 900 >> > > I would say you might be better off using a connection pooler if you need > this many connections. > Yeah that's a lot.

Re: [PERFORM] to many locks held

2013-07-30 Thread bricklen
On Tue, Jul 30, 2013 at 3:52 AM, Jeison Bedoya wrote: > Hi everybody, > > In recent days, we have seen many processes in reaching the lock held 5000. Do you know what queries are holding locks? Is that behaviour expected? > At that time my machine will become sluggish and no response from th

[PERFORM] to many locks held

2013-07-30 Thread Jeison Bedoya
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 t