Postgres Pro
Downloads
Home   >   mailing lists

Re: [HACKERS] 'Waiting on lock' - Mailing list pgsql-patches

From Tom Lane
Subject Re: [HACKERS] 'Waiting on lock'
Date
Msg-id 8287.1182275597@sss.pgh.pa.us
Whole thread Raw
In response to Re: [HACKERS] 'Waiting on lock'  (Gregory Stark <stark@enterprisedb.com>)
List pgsql-patches
Tree view 
Gregory Stark <stark@enterprisedb.com> writes:
> Attached is a patch which moves the messages to ProcSleep().

BTW, with the messages moved out of the ISR it would be safe to make it
identify the specific lock being waited on (in the same terms used in
the existing deadlock messages).  Is there a reason not to do that?
I suppose it would eat a few more cycles ...

            regards, tom lane

pgsql-patches by date:

Previous
From: Alvaro Herrera
Date:
Subject: more autovacuum fixes
Next
From: Alvaro Herrera
Date:
Subject: Re: more autovacuum fixes