X-Original-To: pgsql-performance-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 6DA899FB281 for ; Tue, 11 Jul 2006 04:39:51 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 99356-02-2 for ; Tue, 11 Jul 2006 04:39:46 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from service-web.de (p15093784.pureserver.info [217.160.106.224]) by postgresql.org (Postfix) with ESMTP id 0D2639FB278 for ; Tue, 11 Jul 2006 04:39:46 -0300 (ADT) Received: from [10.100.1.52] (074-016-066-080.eggenet.de [80.66.16.74]) by service-web.de (Postfix) with ESMTP id 9334D20002D; Tue, 11 Jul 2006 09:39:43 +0200 (CEST) Message-ID: <44B355BC.3040907@wildenhain.de> Date: Tue, 11 Jul 2006 09:39:40 +0200 From: Tino Wildenhain User-Agent: Thunderbird 1.5.0.4 (X11/20060619) MIME-Version: 1.0 To: "Craig A. James" Cc: pgsql-performance@postgresql.org Subject: Re: Kill a session References: <44B33C30.2070209@modgraph-usa.com> In-Reply-To: <44B33C30.2070209@modgraph-usa.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200607/93 X-Sequence-Number: 19953 Craig A. James wrote: > There have been dozens, perhaps hundreds, of entries in the pg-admin, > pg-general, and pg-performance lists regarding killing a session, but as > far as I can tell, there is no Postgres solution. Did I miss something? > > This raises the question: Why doesn't Postgres have a "kill session" > command that works? Oracle has it, and it's invaluable; there is no > substitute. Various writers to these PG lists have raised the question > repeatedly. Is it just a matter that nobody has had the time to do it > (which I respect!), or is there a reason why the Postgres team decided a > "kill session" is a bad idea? You are sure you read: http://www.postgresql.org/docs/8.1/interactive/protocol-flow.html#AEN60635 ? Regards Tino Wildenhain