X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 57A819FA9BD for ; Tue, 2 May 2006 20:59:42 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 91269-07 for ; Tue, 2 May 2006 20:59:26 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from projects.commandprompt.com (host-130.commandprompt.net [207.173.203.130]) by postgresql.org (Postfix) with ESMTP id 75A549FAA6E for ; Tue, 2 May 2006 20:59:26 -0300 (ADT) Received: from [192.168.3.5] (dsl.static8121514250.ttnet.net.tr [81.215.14.250] (may be forged)) (authenticated bits=0) by projects.commandprompt.com (8.13.4/8.13.4) with ESMTP id k42NxKVn003145; Tue, 2 May 2006 16:59:21 -0700 Subject: Re: Killing long-running queries From: Devrim GUNDUZ To: Dan Harris Cc: PostgreSQL Performance In-Reply-To: <4457E918.10007@drivefaster.net> References: <4457E918.10007@drivefaster.net> Content-Type: text/plain Organization: Command Prompt, Inc. Date: Wed, 03 May 2006 03:01:16 +0300 Message-Id: <1146614476.2471.28.camel@laptop.gunduz.org> Mime-Version: 1.0 X-Mailer: Evolution 2.6.0 (2.6.0-1) Content-Transfer-Encoding: 7bit X-Virus-Scanned: ClamAV version 0.88, clamav-milter version 0.87 on projects.commandprompt.com X-Virus-Status: Clean X-Greylist: Sender succeded SMTP AUTH authentication, not delayed by milter-greylist-1.6 (projects.commandprompt.com [192.168.2.159]); Tue, 02 May 2006 16:59:23 -0700 (PDT) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/66 X-Sequence-Number: 18853 Hi, On Tue, 2006-05-02 at 17:19 -0600, Dan Harris wrote: > Is there some way I can just kill a query and not risk breaking > everything else when I do it? Use pg_stat_activity view to find the pid of the process (pidproc column) and send the signal to that process. I think you are now killing postmaster, which is wrong. Regards, -- The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/