From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
---|---|
To: | Dan Halbert <halbert(at)halwitz(dot)org> |
Cc: | pgadmin-support(at)postgresql(dot)org |
Subject: | Re: orphaned runaway queries after killing pgadmin |
Date: | 2010-11-15 20:18:31 |
Message-ID: | 4CE19597.7050006@lelarge.info |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
Le 15/11/2010 21:10, Dan Halbert a écrit :
> Today I end up killing pgadmin a few times while inadvertantly
> running some huge queries and some ALTER requests that were blocked
> due to the queries. I should have canceled the queries from pgadmin,
> but I didn't. When I saw that the postgres processes were using up
> 100% of the CPU, I looked up the process id's of the ALTERs and
> runaway queries in pg_stat_activity and did the equivalent of "pg_ctl
> kill".
>
> I don't think this is really pgadmin's fault, but why doesn't
> PostgreSQL notice that the query requestor has vanished and quit
> working on the query? Apologies if you think I should ask this on a
> general PG list.
>
You're right that it's not pgAdmin's fault. Question is: how could
PostgreSQL know the client is killed? I don't have the answer unfortunately.
--
Guillaume
http://www.postgresql.fr
http://dalibo.com
From | Date | Subject | |
---|---|---|---|
Next Message | Dan Shoubridge | 2010-11-16 12:14:39 | Feature Request for Debugging SQL in PGAdmin3 when SQL contains variables |
Previous Message | Dan Halbert | 2010-11-15 20:10:56 | orphaned runaway queries after killing pgadmin |