From: Shoaib Mir <shoaibmir@gmail.com>
To: jose fuenmayor <jafn82@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Issue with processes open for clients
Date: Fri, 10 Nov 2006 16:12:21 +0500
Message-ID: <bf54be870611100312s69fb5710pb726406808e9bb8d@mail.gmail.com> (raw)
In-Reply-To: <69f2062a0611091154t6a345360g165dd0e80495bcb7@mail.gmail.com>
References: <69f2062a0611091154t6a345360g165dd0e80495bcb7@mail.gmail.com>
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!
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: shoaibmir@gmail.com, jafn82@gmail.com
Subject: Re: Issue with processes open for clients
In-Reply-To: <bf54be870611100312s69fb5710pb726406808e9bb8d@mail.gmail.com>
References: <69f2062a0611091154t6a345360g165dd0e80495bcb7@mail.gmail.com> <bf54be870611100312s69fb5710pb726406808e9bb8d@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox