| From: | Tony Wang <wwwjfy(at)gmail(dot)com> |
|---|---|
| To: | John R Pierce <pierce(at)hogranch(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Weird problem that enormous locks |
| Date: | 2011-07-15 05:26:39 |
| Message-ID: | CAH1z_A5pth9s+sA-RABy9tjT4BX_PK70+3hdhzfLG-EJLLuhaA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, Jul 15, 2011 at 12:38, John R Pierce <pierce(at)hogranch(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/**mailpref/pgsql-general<http://www.postgresql.org/mailpref/pgsql-general>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Radoslaw Smogura | 2011-07-15 07:33:04 | Re: Weird problem that enormous locks |
| Previous Message | nike | 2011-07-15 05:10:16 | Path Application Postgresql on Windows XP 64 bit |