Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 71C429FB2DE for ; Fri, 10 Nov 2006 07:12:27 -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 50810-01 for ; Fri, 10 Nov 2006 07:12:23 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from nz-out-0102.google.com (nz-out-0102.google.com [64.233.162.202]) by postgresql.org (Postfix) with ESMTP id 4EA8D9FB2DD for ; Fri, 10 Nov 2006 07:12:23 -0400 (AST) Received: by nz-out-0102.google.com with SMTP id i11so275901nzh for ; Fri, 10 Nov 2006 03:12:22 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=Fyh9cNcnv+bArELMe6vxsWg3vzP6sUC5yDCGPHdOnqTTId5FvCr/xzwE1e6Rw6dViABT3yOiUWuL7ifQFPobWm4x/gBsrRA8eaHzDADGT/W1owJohEPSRr+S2oVuj/fe2dDS5b3VUMeRjMhHTY0qLHEpIxiQ/1JhtrIfDOnsSjE= Received: by 10.64.185.7 with SMTP id i7mr2958552qbf.1163157141596; Fri, 10 Nov 2006 03:12:21 -0800 (PST) Received: by 10.65.253.20 with HTTP; Fri, 10 Nov 2006 03:12:21 -0800 (PST) Message-ID: Date: Fri, 10 Nov 2006 16:12:21 +0500 From: "Shoaib Mir" To: "jose fuenmayor" Subject: Re: Issue with processes open for clients Cc: pgsql-admin@postgresql.org In-Reply-To: <69f2062a0611091154t6a345360g165dd0e80495bcb7@mail.gmail.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_36667_14253259.1163157141513" References: <69f2062a0611091154t6a345360g165dd0e80495bcb7@mail.gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/101 X-Sequence-Number: 23628 ------=_Part_36667_14253259.1163157141513 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline If you don't need the client connection after query has executed then just close that client connection or you can have it set in your firewall to kill such idle connections who are not doing anything. Thanks, -------- Shoaib Mir EnterpriseDB (www.enterprisedb.com) On 11/10/06, 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? > > The process stays hanging there? > why is that?. > Is there any parameter on postgresql or the operating system that can > tune? > I am using mandriva linux free 2006 > kernel 2.6.12 > Postgresql 8.0.8 > phpPgAdmin 4.0.1 (running in a web server whit php module 5.0.4) > > Same thing using phpPgAdmin > > Thanks in advance! I really aprecciate your help! > ------=_Part_36667_14253259.1163157141513 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline If you don't need the client connection after query has executed then just close that client connection or you can have it set in your firewall to kill such idle connections who are not doing anything.

Thanks,
--------
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)

On 11/10/06, jose fuenmayor < jafn82@gmail.com> 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?

The process stays hanging there?
why is that?.
Is there any parameter on postgresql or the operating system that can tune?
I am using mandriva linux free 2006
kernel 2.6.12
Postgresql 8.0.8
phpPgAdmin 4.0.1 (running in a web server whit php module 5.0.4)

Same thing using phpPgAdmin

Thanks in advance! I really aprecciate your help!

------=_Part_36667_14253259.1163157141513--