Re: pg_terminate_backend - Mailing list pgsql-hackers

From Csaba Nagy
Subject Re: pg_terminate_backend
Date
Msg-id 1154623004.21451.82.camel@coppola.muc.ecircle.de
Whole thread Raw
In response to Re: pg_terminate_backend  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: pg_terminate_backend
List pgsql-hackers
> "Stuck?"  You have not shown us a case where SIGTERM rather than SIGINT
> is necessary or appropriate.  It seems to me the above is assuming the
> existence of unknown backend bugs, exactly the same thing you think
> I shouldn't be assuming ...

I do know a case where a plain kill will seem to be stucked: on vacuum
of a big table. I guess when it starts an index's cleanup scan it will
insist to finish it before stopping. I'm not sure if that's the cause,
but I have seen delays of 30 minutes for killing a vacuum... it's true
that finally it always did die... but it's also true that I have 'kill
-9'-ed it before because I thought it's stucked.

Cheers,
Csaba.




pgsql-hackers by date:

Previous
From: Joachim Wieland
Date:
Subject: Re: ecpg test suite
Next
From: Tom Lane
Date:
Subject: Re: ecpg test suite