Postgres Pro
Downloads
Home   >   mailing lists

Re: Weird problem that enormous locks - Mailing list pgsql-general

From John R Pierce
Subject Re: Weird problem that enormous locks
Date
Msg-id 4E1FC438.2020405@hogranch.com
Whole thread Raw
In response to Re: Weird problem that enormous locks  (Tony Wang <wwwjfy@gmail.com>)
Responses Re: Weird problem that enormous locks
List pgsql-general
Tree view 
On 07/14/11 7:58 PM, Tony Wang wrote:
>
> There were 2519 RowExclusiveLock and 85 ExclusiveLock

how could 800 max_connections have 2519 row locks ?  do you update
multiple different rows in the same transaction?



--
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast

pgsql-general by date:

Previous
From: Tony Wang
Date:
Subject: Re: Weird problem that enormous locks
Next
From: Tony Wang
Date:
Subject: Re: Weird problem that enormous locks