On 13 December 2016 at 01:17, Andrew Borodin <borodin@octonica.com> wrote:
> 6. Cancelation: a way to signal to background query that it's time to
> quit gracefully.
That at least should be fuss-free. SIGTERM it, and make sure the
worker does CHECK_FOR_INTERRUPTS() in regularly-hit places and loops.
Ensure the worker waits on latches rather than pg_usleep()ing.
-- Craig Ringer http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training & Services