Skip site navigation (1) Skip section navigation (2)

Re: trivial patch: show SIREAD pids in pg_locks

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Dan Ports" <drkp(at)csail(dot)mit(dot)edu>
Cc: <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: trivial patch: show SIREAD pids in pg_locks
Date: 2011-04-01 19:23:00
Message-ID: 4D95DFC4020000250003C146@gw.wicourts.gov (view raw or flat)
Thread:
Lists: pgsql-hackers
Dan Ports <drkp(at)csail(dot)mit(dot)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: patch-ssi-pid-in-pg_locks.txt
Description: text/plain (1.4 KB)

In response to

pgsql-hackers by date

Next:From: Jan WieckDate: 2011-04-01 19:42:06
Subject: Re: Lock problem with autovacuum truncating heap
Previous:From: Dan PortsDate: 2011-04-01 18:42:55
Subject: Re: trivial patch: show SIREAD pids in pg_locks

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group