Re: [HACKERS] pg_background contrib module proposal - Mailing list pgsql-hackers

From Craig Ringer
Subject Re: [HACKERS] pg_background contrib module proposal
Date
Msg-id CAMsr+YFrmWPpVOD8wyBvfKK9haDXFbfKd_SEzXXT_MovP=0HPw@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] pg_background contrib module proposal  (Andrew Borodin <borodin@octonica.com>)
List pgsql-hackers
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



pgsql-hackers by date:

Previous
From: Amit Langote
Date:
Subject: Re: [HACKERS] Declarative partitioning - another take
Next
From: Michael Paquier
Date:
Subject: Re: [HACKERS] jsonb problematic operators