Re: Weird problem that enormous locks

Поиск
Список
Период
Сортировка
От Tony Wang
Тема Re: Weird problem that enormous locks
Дата
Msg-id CAH1z_A5pth9s+sA-RABy9tjT4BX_PK70+3hdhzfLG-EJLLuhaA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Weird problem that enormous locks  (John R Pierce <pierce@hogranch.com>)
Список pgsql-general
Дерево обсуждения
On Fri, Jul 15, 2011 at 12:38, John R Pierce <pierce@hogranch.com> wrote:
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?


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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

В списке pgsql-general по дате отправления:

Предыдущее
От: John R Pierce
Дата:
Сообщение: Re: Weird problem that enormous locks
Следующее
От: Mike Christensen
Дата:
Сообщение: Re: pgAdmin on Mac connecting to Postgres 9 on Linux - SSL/timeout issue