Re: Blocking excessively in FOR UPDATE
От | Claudio Freire |
---|---|
Тема | Re: Blocking excessively in FOR UPDATE |
Дата | |
Msg-id | CAGTBQpYK6-ycWr0WXRwz39Bv30sCbDe68CC3MbhUp9-jwu_V=g@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: Blocking excessively in FOR UPDATE (Claudio Freire <klaussfreire@gmail.com>) |
Ответы |
Re: Blocking excessively in FOR UPDATE
(Tom Lane <tgl@sss.pgh.pa.us>)
|
Список | pgsql-performance |
On Thu, Nov 3, 2011 at 4:29 PM, Claudio Freire <klaussfreire@gmail.com> wrote: > Next time I find it blocking, I will check pg_locks directly and post > the output. Here it is, two instances of the query, while blocked: select * from pg_locks where pid = 22636; locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted ---------------+----------+----------+------+-------+-------------+---------------+---------+-------+----------+--------------------+-------+------------------+--------- transactionid | | | | | | 360992199 | | | | 89/22579344 | 22636 | ExclusiveLock | t virtualxid | | | | | 89/22579344 | | | | | 89/22579344 | 22636 | ExclusiveLock | t relation | 16398 | 5552020 | | | | | | | | 89/22579344 | 22636 | AccessShareLock | t relation | 16398 | 5552020 | | | | | | | | 89/22579344 | 22636 | RowExclusiveLock | t relation | 16398 | 5552019 | | | | | | | | 89/22579344 | 22636 | AccessShareLock | t relation | 16398 | 5552019 | | | | | | | | 89/22579344 | 22636 | RowExclusiveLock | t relation | 16398 | 5525292 | | | | | | | | 89/22579344 | 22636 | RowShareLock | t relation | 16398 | 5525292 | | | | | | | | 89/22579344 | 22636 | RowExclusiveLock | t relation | 16398 | 5552008 | | | | | | | | 89/22579344 | 22636 | AccessShareLock | t relation | 16398 | 5552008 | | | | | | | | 89/22579344 | 22636 | RowExclusiveLock | t (10 rows) select * from pg_locks where pid = 22618; locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted ---------------+----------+----------+------+-------+-------------+---------------+---------+-------+----------+--------------------+-------+------------------+--------- virtualxid | | | | | 159/2706505 | | | | | 159/2706505 | 22618 | ExclusiveLock | t relation | 16398 | 5551986 | | | | | | | | 159/2706505 | 22618 | AccessShareLock | t transactionid | | | | | | 360992478 | | | | 159/2706505 | 22618 | ExclusiveLock | t relation | 16398 | 5552008 | | | | | | | | 159/2706505 | 22618 | AccessShareLock | t relation | 16398 | 5552008 | | | | | | | | 159/2706505 | 22618 | RowExclusiveLock | t relation | 16398 | 5526310 | | | | | | | | 159/2706505 | 22618 | RowShareLock | t relation | 16398 | 5552020 | | | | | | | | 159/2706505 | 22618 | AccessShareLock | t relation | 16398 | 5552020 | | | | | | | | 159/2706505 | 22618 | RowExclusiveLock | t relation | 16398 | 5526308 | | | | | | | | 159/2706505 | 22618 | AccessShareLock | t relation | 16398 | 5552019 | | | | | | | | 159/2706505 | 22618 | AccessShareLock | t relation | 16398 | 5552019 | | | | | | | | 159/2706505 | 22618 | RowExclusiveLock | t relation | 16398 | 5525296 | | | | | | | | 159/2706505 | 22618 | RowShareLock | t relation | 16398 | 5525292 | | | | | | | | 159/2706505 | 22618 | RowShareLock | t relation | 16398 | 5525292 | | | | | | | | 159/2706505 | 22618 | RowExclusiveLock | t (14 rows)
В списке pgsql-performance по дате отправления:
Следующее
От: Mario WeilguniДата:
Сообщение: Re: Performance Problem with postgresql 9.03, 8GB RAM,Quadcore Processor Server--Need help!!!!!!!