Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 414109FA4C3 for ; Fri, 10 Nov 2006 17:47:04 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 31999-01 for ; Fri, 10 Nov 2006 17:47:01 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail01.enterprisedb.com (mail01.enterprisedb.com [63.246.7.168]) by postgresql.org (Postfix) with ESMTP id E55EB9FA2C7 for ; Fri, 10 Nov 2006 17:46:59 -0400 (AST) thread-index: AccFEcDSji3dkAabTOqiCcHv4cewGg== Received: from [192.168.0.31] ([84.12.80.212]) by mail01.enterprisedb.com with Microsoft SMTPSVC(6.0.3790.1830); Fri, 10 Nov 2006 16:47:00 -0500 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.2757 Content-class: urn:content-classes:message Importance: normal Subject: Re: Issue with processes open for clients From: "Simon Riggs" To: "jose fuenmayor" Cc: In-Reply-To: <69f2062a0611091154t6a345360g165dd0e80495bcb7@mail.gmail.com> References: <69f2062a0611091154t6a345360g165dd0e80495bcb7@mail.gmail.com> Content-Type: text/plain; charset="iso-8859-1" Date: Fri, 10 Nov 2006 21:46:23 +0000 Message-ID: <1163195184.3634.924.camel@silverbirch.site> MIME-Version: 1.0 X-Mailer: Evolution 2.6.0 Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 10 Nov 2006 21:47:01.0031 (UTC) FILETIME=[C0C8B370:01C70511] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/114 X-Sequence-Number: 23641 On Thu, 2006-11-09 at 19:54 +0000, jose fuenmayor wrote: > Hi all , I have a question or a doubt, when I ran psql remotely it > opens a process on the server, so I issue a query (select count(*) > from 80millionsrowstable) then I can see that process taking cpu and > mem from the server (using top), then I cancel the psql on the client, > I expect to see that process gone but that is not the case it is still > there! and taking resources!. > > When I cancelled the query issued by the client is not supposed to > eliminate the process open for him on the server? If you quit psql, then the server may not realise you have disconnected. You need to issue a cancel, so that can be communicated to the server so it knows to quit. -- Simon Riggs EnterpriseDB http://www.enterprisedb.com