Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id EA8249FB724 for ; Thu, 17 May 2007 07:39:21 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 38144-05 for ; Thu, 17 May 2007 07:38:51 -0300 (ADT) X-Greylist: delayed 00:18:47.86376 by SQLgrey-1.7.5 Received: from mail.contextworld.com (mail.contextworld.com [82.108.167.183]) by postgresql.org (Postfix) with ESMTP id 7F8F29FBE42 for ; Thu, 17 May 2007 07:39:17 -0300 (ADT) Message-Id: <4EE567E3B6.06240021TFSWLQQC@contextworld.com> From: rwickert@contextworld.com Date: Thu, 17 May 2007 11:20:00 +0100 To: pgsql-admin@postgresql.org Subject: Multiple long-running queries hang pgAdm X-Mailer: TFS Secure Messaging Server /221000000/221040833/221001340/221080876/ X-Mailer: Version 5.1 Build 101 MIME-version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-transfer-encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.776 tagged_above=0 required=5 tests=BAYES_40=-0.185, NO_REAL_NAME=0.961 X-Spam-Level: X-Archive-Number: 200705/155 X-Sequence-Number: 25475 Hi, PgAdmin Version: pgAdmin III 1=2E6=2E3 on Windows XP Postgresql: 8=2E1 on SUSE Enterprise Linux Why does pgAdmin hang when I run more than one long-running query? During=20= that time pgAdmin is completely frozen to me=2E It does not come back until=20= at least one but sometimes both of the queries are finished=2E What is the=20= reason for this each window runs on a seperate postgresql process=2E It means that whenever I want to run more than one long-running query I=20= have to open seperate pgAdmin's=2E Thanks for your help ***************************************************** Robert Wickert Senior Software Developer CONTEXT Tel:+44 (0)20 8394 7739 Fax:+44 (0)20 8394 7701 Email Address: rwickert@contextworld=2Ecom Web Site: http://www=2Econtextworld=2Ecom ***************************************************** This message and the information contained therein is intended for the use of the person(s) ("the intended recipient(s)" to whom it is addressed=2E It may contain information that is privileged and confidential within the meaning of applicable law=2E If you are not the intended recipient, please contact the sender as soon possible=2E The views expressed in this communication may not necessarily be the views held by Context or its subsidiaries=2E The contents of an attachment to this e-mail may contain viruses that could damage your own computer system=2E While every reasonable precaution has been taken to minimise this risk, Context and its subsidiaries cannot accept liability for any damage which you sustain as a result of software viruses=2E You should carry out your own virus checks before opening the attachment=2E Please notice that Context monitors e-mails sent or received=2E Further communication will signify your consent to this=2E