Re: Notice lock waits - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Notice lock waits
Date
Msg-id 17899.1470424648@sss.pgh.pa.us
Whole thread Raw
In response to Notice lock waits  (Jeff Janes <jeff.janes@gmail.com>)
Responses Re: Notice lock waits  (Jeff Janes <jeff.janes@gmail.com>)
List pgsql-hackers
Jeff Janes <jeff.janes@gmail.com> writes:
> I have it PGC_SUSET because it does send some tiny amount of
> information about the blocking process (the PID) to the blocked
> process.  That is probably too paranoid, because the PID can be seen
> by anyone in the pg_locks table anyway.

Why not just leave out the PID?  I think it's often far too simplistic
to blame a lock wait on a single other process, anyway.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Julien Rouhaud
Date:
Subject: Re: Notice lock waits
Next
From: Bruce Momjian
Date:
Subject: Re: Heap WARM Tuples - Design Draft