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
