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
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
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.
