Re: [HACKERS] How to kill a Background worker and Its metadata

2016-06-28 Thread Akash Agrawal
inger wrote: > On 28 June 2016 at 02:27, Akash Agrawal wrote: > >> Hi, >> >> I've created a background worker and I am using Postgresql-9.4. This >> bgworker handles the job queue dynamically and goes to sleep if there is no >> job to process within the next 1

Re: [HACKERS] How to kill a Background worker and Its metadata

2016-06-28 Thread Akash Agrawal
elect worker_spi1_launch(1) to launch it every time. This is why I guess there is some metadata maintained which has got to be deleted. On Mon, Jun 27, 2016 at 7:59 PM, Michael Paquier wrote: > On Tue, Jun 28, 2016 at 3:27 AM, Akash Agrawal wrote: > > I've created a background wo

[HACKERS] How to kill a Background worker and Its metadata

2016-06-27 Thread Akash Agrawal
Hi, I've created a background worker and I am using Postgresql-9.4. This bgworker handles the job queue dynamically and goes to sleep if there is no job to process within the next 1 hour. Now, I want to have a mechanism to wake the bgworker up in case if someone adds a new job while the bgworker