| From: | "Simon Riggs" <simon(at)2ndquadrant(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 21:46:23 |
| Message-ID: | 1163195184.3634.924.camel@silverbirch.site |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Claudio Novaes | 2006-11-11 13:52:03 | teste |
| Previous Message | imad | 2006-11-10 21:20:42 | Re: Issue with processes open for clients |