Re: Background Processes in Postgres Extension

2024-04-28 Thread Ashutosh Bapat
On Sat, Apr 27, 2024 at 9:26 PM Sushrut Shivaswamy < sushrut.shivasw...@gmail.com> wrote: > Thanks for the suggestion on using postgres background worker. > > I tried creating one following the implementation in worker_spi and am > able to spawn a background worker successfully. > > However, the b

Re: Background Processes in Postgres Extension

2024-04-27 Thread Sushrut Shivaswamy
Thanks for the suggestion on using postgres background worker. I tried creating one following the implementation in worker_spi and am able to spawn a background worker successfully. However, the background worker seems to cause postmaster to crash when I wait for it to finish using `WaitForBackgr

Re: Background Processes in Postgres Extension

2024-04-23 Thread Tom Lane
Sushrut Shivaswamy writes: > I'm developing a postgres extension as a custom Table Interface method > definition. > WIthin the extension, I"m planning to create two background processes using > `fork()` that will process data in the background. > Are there any recommendations / guidelines around

Background Processes in Postgres Extension

2024-04-23 Thread Sushrut Shivaswamy
Hey, I'm developing a postgres extension as a custom Table Interface method definition. WIthin the extension, I"m planning to create two background processes using `fork()` that will process data in the background. Are there any recommendations / guidelines around creating background processes wi