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

Multiple long-running queries hang pgAdm

From: rwickert(at)contextworld(dot)com
To: pgsql-admin(at)postgresql(dot)org
Subject: Multiple long-running queries hang pgAdm
Date: 2007-05-17 10:20:00
Message-ID: 4EE567E3B6.06240021TFSWLQQC@contextworld.com (view raw or flat)
Thread:
Lists: pgsql-admin
Hi,

PgAdmin Version: pgAdmin III 1.6.3 on Windows XP
Postgresql: 8.1 on SUSE Enterprise Linux

Why does pgAdmin hang when I run more than one long-running query? During that time pgAdmin is completely frozen to me. It does not come back until at least one but sometimes both of the queries are finished. What is the reason for this each window runs on a seperate postgresql process.

It means that whenever I want to run more than one long-running query I have to open seperate pgAdmin's.

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(at)contextworld(dot)com
Web Site: http://www.contextworld.com
*****************************************************
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. It
may contain information that is privileged and confidential within the
meaning of applicable law. If you are not the intended recipient, please
contact the sender as soon possible. The views expressed in this
communication may not necessarily  be the views held by Context or its
subsidiaries. The contents of an attachment to this e-mail may contain
viruses that could damage your own computer system. 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. You should carry out your own virus checks
before opening the attachment. Please notice that Context monitors e-mails
sent or received. Further communication will signify your consent to this.

pgsql-admin by date

Next:From: Khan, Mahmood AhramDate: 2007-05-17 11:12:57
Subject: WAL FILES
Previous:From: Sorin N. CiolofanDate: 2007-05-17 09:14:17
Subject: Re: increasing of the shared memory does not solve theproblem of "OUT of shared memory"

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