Re: [pgadmin-support] orphaned runaway queries after killing pgadmin

2010-11-15 Thread Guillaume Lelarge
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 proce

[pgadmin-support] orphaned runaway queries after killing pgadmin

2010-11-15 Thread Dan Halbert
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