Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 8DAF19FA5F0 for ; Thu, 9 Nov 2006 15:54:12 -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 96550-10 for ; Thu, 9 Nov 2006 19:54:06 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.172]) by postgresql.org (Postfix) with ESMTP id 643409FA5CE for ; Thu, 9 Nov 2006 15:54:05 -0400 (AST) Received: by ug-out-1314.google.com with SMTP id k3so287109ugf for ; Thu, 09 Nov 2006 11:54:04 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type; b=gPySb/ynQRMlzVPBI3GcBdIfZEVcNZyCJbzNlWwcaR2WVySWWEImw+9H5+mCYO7A02WL2gjj4T+wzPRXN0I2hwk196xHUoxhgO50NKrbGpLaA8bMn6ZsTV2XGWxEU6a3kKNiNBYefm9gXXt3s92fp8Ua1PmYH+1kvXelDQ5mskQ= Received: by 10.78.185.16 with SMTP id i16mr1569199huf.1163102043547; Thu, 09 Nov 2006 11:54:03 -0800 (PST) Received: by 10.78.139.19 with HTTP; Thu, 9 Nov 2006 11:54:03 -0800 (PST) Message-ID: <69f2062a0611091154t6a345360g165dd0e80495bcb7@mail.gmail.com> Date: Thu, 9 Nov 2006 19:54:03 +0000 From: "jose fuenmayor" To: pgsql-admin@postgresql.org Subject: Issue with processes open for clients MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_47494_5643606.1163102043504" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/98 X-Sequence-Number: 23625 ------=_Part_47494_5643606.1163102043504 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline 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_47494_5643606.1163102043504 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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_47494_5643606.1163102043504--