Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id BF7F09F9F7E for ; Mon, 13 Nov 2006 09:38:19 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 75307-04 for ; Mon, 13 Nov 2006 13:38:15 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.174]) by postgresql.org (Postfix) with ESMTP id 32C8C9F9C52 for ; Mon, 13 Nov 2006 09:38:14 -0400 (AST) Received: by ug-out-1314.google.com with SMTP id k3so899950ugf for ; Mon, 13 Nov 2006 05:38:13 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references; b=cUi/O6Vookji8HGboITSpELP5VWE2t6UNSgQGDjlUxajU80fKcpnX9KhnSkh7GyKFS4NK108sKCweDJ0cnmiRMs5tNLk8tZ1S/sW/UVTdiDyvtAlTSCtJwfvXpHGT+bvhDyl8zh41GttjGWgVy10HMjm20SEa1QL3LUXLTCio+s= Received: by 10.78.39.16 with SMTP id m16mr6024596hum.1163425092245; Mon, 13 Nov 2006 05:38:12 -0800 (PST) Received: by 10.78.139.19 with HTTP; Mon, 13 Nov 2006 05:38:11 -0800 (PST) Message-ID: <69f2062a0611130538he92b0a5u79dbf8ca95313080@mail.gmail.com> Date: Mon, 13 Nov 2006 09:38:11 -0400 From: "jose fuenmayor" To: "Simon Riggs" , pgsql-admin@postgresql.org Subject: Re: Issue with processes open for clients In-Reply-To: <1163195184.3634.924.camel@silverbirch.site> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_91493_15875640.1163425091668" References: <69f2062a0611091154t6a345360g165dd0e80495bcb7@mail.gmail.com> <1163195184.3634.924.camel@silverbirch.site> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/120 X-Sequence-Number: 23647 ------=_Part_91493_15875640.1163425091668 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline Thanks for your answer! How can i issue a cancel? thanks in advance! On 11/10/06, Simon Riggs wrote: > > 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 > > > ------=_Part_91493_15875640.1163425091668 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Thanks for your answer!
How can i issue a cancel?
thanks in advance!
On 11/10/06, Simon Riggs <simon@2ndquadrant.com> wrote:
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



------=_Part_91493_15875640.1163425091668--