X-Original-To: pgsql-performance@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id B86E6475A71 for ; Tue, 25 Mar 2003 10:30:46 -0500 (EST) Received: from mail.libertyrms.com (unknown [209.167.124.227]) by postgresql.org (Postfix) with ESMTP id 7B204474E44 for ; Tue, 25 Mar 2003 10:30:45 -0500 (EST) Received: from andrew by mail.libertyrms.com with local (Exim 3.22 #3 (Debian)) id 18xqO1-0007RP-00 for ; Tue, 25 Mar 2003 10:30:49 -0500 Date: Tue, 25 Mar 2003 10:30:49 -0500 From: Andrew Sullivan To: pgsql-performance@postgresql.org Subject: Re: Finding the PID keeping a transaction open Message-ID: <20030325103049.A28249@mail.libertyrms.com> Mail-Followup-To: Andrew Sullivan , pgsql-performance@postgresql.org References: <20030325081233.B18817@mail.libertyrms.com> <28390.1048603061@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: <28390.1048603061@sss.pgh.pa.us>; from tgl@sss.pgh.pa.us on Tue, Mar 25, 2003 at 09:37:41AM -0500 X-Spam-Status: No, hits=-38.0 required=5.0 tests=BAYES_10,EMAIL_ATTRIBUTION,IN_REP_TO,QUOTED_EMAIL_TEXT, REFERENCES,REPLY_WITH_QUOTES,USER_AGENT_MUTT autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200303/174 X-Sequence-Number: 1472 On Tue, Mar 25, 2003 at 09:37:41AM -0500, Tom Lane wrote: > In 7.3 you could look at the pg_locks system view, but I can't think > of any reasonable way to do it in 7.2 :-( Thanks. I was afraid you'd say that. Rats. > would take many minutes --- which you'd have to do with the LockMgr lock > held to keep them from changing underneath you. This seems quite Well, then, _that's_ a non-starter. Ugh. > It's conceivable that some version of the pg_locks code could be > back-ported to 7.2 --- you'd have to settle for dumping the info to > the log, probably, due to lack of table-function support, but it > could be done. I think it's probably better just to work on making the whole thing work correctly with 7.3, instead. I'm keen to move it, and 7.3 seems stable enough, so I'm inclined just to move that up in priority. Thanks, A -- ---- Andrew Sullivan 204-4141 Yonge Street Liberty RMS Toronto, Ontario Canada M2P 2A8 +1 416 646 3304 x110