Re: trivial patch: show SIREAD pids in pg_locks - Mailing list pgsql-hackers

From Kevin Grittner
Subject Re: trivial patch: show SIREAD pids in pg_locks
Date
Msg-id 4D95DFC4020000250003C146@gw.wicourts.gov
Whole thread Raw
In response to Re: trivial patch: show SIREAD pids in pg_locks  (Dan Ports <drkp@csail.mit.edu>)
List pgsql-hackers
Dan Ports <drkp@csail.mit.edu> wrote:

> There's no urgent need to have this, although it's obviously more
> correct than the current behavior. It might be useful for
> debugging.

Agreed all around.  For the benefit of the more casual follower of
the thread, attached is a simple example of the output.  For the
SIReadLock rows, the pid column shows as empty without the patch.

-Kevin


Attachment

pgsql-hackers by date:

Previous
From: Dan Ports
Date:
Subject: Re: trivial patch: show SIREAD pids in pg_locks
Next
From: Jan Wieck
Date:
Subject: Re: Lock problem with autovacuum truncating heap