Query kill

From: Rudi Starcevic <rudi(at)oasis(dot)net(dot)au>
To: pgsql-sql(at)postgresql(dot)org
Subject: Query kill
Date: 2002-07-12 05:00:51
Message-ID: 3D2E6283.4090101@oasis.net.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hello,

If I write a query that is inefficient or in an eternal loop how
do I stop it without restarting the postmaster ?

I can see many postmaster processed appearing in the output of the 'ps'
command.
Do I need to stop/kill them all or can I stop just the query I want ?

Thanks heaps
Rudi.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Bruce Momjian 2002-07-12 05:01:31 Re: Query kill
Previous Message Christopher Kings-Lynne 2002-07-12 01:39:57 Re: PostgreSQL - contrib/xml