On Wed, 2007-10-24 at 07:57 +0200, Stefan Schwarzer wrote:
> Hi there,
> 
> 
> I read dozens of times the "TIP 2: Don't 'kill -9' the postmaster"...
> 
> 
> Now, what am I supposed to do if I launched a query which takes ages,
> and which I want to interrupt? 


look for the query's procpid and then issue a select
pg_cancel_backend('the_id')

> 

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Reply via email to