Skip site navigation (1) Skip section navigation (2)

Re: Issue with processes open for clients

From: "Shoaib Mir" <shoaibmir(at)gmail(dot)com>
To: "jose fuenmayor" <jafn82(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Issue with processes open for clients
Date: 2006-11-10 11:12:21
Message-ID: bf54be870611100312s69fb5710pb726406808e9bb8d@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
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(at)gmail(dot)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!
>

In response to

Responses

pgsql-admin by date

Next:From: Gergely CZUCZYDate: 2006-11-10 12:05:22
Subject: schemas and tablespaces
Previous:From: jatrojoomlaDate: 2006-11-10 08:14:43
Subject: how & from where to start & admin pgsql on red hat ES 3

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group