On Fri, Jul 15, 2011 at 12:38, John R Pierce <pierce@xxxxxxxxxxxx> wrote:
On 07/14/11 7:58 PM, Tony Wang wrote:how could 800 max_connections have 2519 row locks ? do you update multiple different rows in the same transaction?
There were 2519 RowExclusiveLock and 85 ExclusiveLock
the row locks includes indexes locks, also some updates related to two tables. Roughly, about 700+ unique RowExclusiveLock there
--
john r pierce N 37, W 122
santa cruz ca mid-left coast
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
