Re: Switch background worker on/off in runtime.

Поиск
Список
Период
Сортировка
От Kashif Zeeshan
Тема Re: Switch background worker on/off in runtime.
Дата
Msg-id CAAPsdheFU6fjKq3omSLc7qBXLw5zkr_s17W_XMi6aTJRCysd2w@mail.gmail.com
обсуждение исходный текст
Ответ на Switch background worker on/off in runtime.  ("ISHAN CHHANGANI ." <f20200230@hyderabad.bits-pilani.ac.in>)
Список pgsql-hackers
Hi ISHAN



On Fri, May 31, 2024 at 2:28 PM ISHAN CHHANGANI . <f20200230@hyderabad.bits-pilani.ac.in> wrote:

Hi,

Is it possible to switch on/off a background worker in runtime?

As per my understanding there is no such way to do it on runtime. But you can kill it by using the following command

select pg_terminate_backend(pid of bgworker);

Regards
Kashif Zeeshan
Bitnine Global 


worker.bgw_flags = BGWORKER_SHMEM_ACCESS;

worker.bgw_start_time = BgWorkerStart_PostmasterStart;

 

I want to switch off the worker based on some flag value, etc, either from the main process or the worker itself.


Are there any already existing examples?

Thanks,

Ishan.


The information contained in this electronic communication is intended solely for the individual(s) or entity to which it is addressed. It may contain proprietary, confidential and/or legally privileged information. Any review, retransmission, dissemination, printing, copying or other use of, or taking any action in reliance on the contents of this information by person(s) or entities other than the intended recipient is strictly prohibited and may be unlawful. If you have received this communication in error, please notify us by responding to this email or telephone and immediately and permanently delete all copies of this message and any attachments from your system(s). The contents of this message do not necessarily represent the views or policies of BITS Pilani.

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Dmitry Dolgov
Дата:
Сообщение: Re: Schema variables - new implementation for Postgres 15
Следующее
От: Aleksander Alekseev
Дата:
Сообщение: Re: meson "experimental"?