Re: Support worker_spi to execute the function dynamically. - Mailing list pgsql-hackers

From Andres Freund
Subject Re: Support worker_spi to execute the function dynamically.
Date
Msg-id 20230728203415.m6sw4ulpfnixtfin@awork3.anarazel.de
Whole thread Raw
In response to Re: Support worker_spi to execute the function dynamically.  (Michael Paquier <michael@paquier.xyz>)
Responses Re: Support worker_spi to execute the function dynamically.
List pgsql-hackers
Hi,

On 2023-07-28 13:45:29 +0900, Michael Paquier wrote:
> Having each bgworker on its own schema would be enough to prevent
> conflicts, but I'd like to add a second thing: a check on
> pg_stat_activity.wait_event after starting the workers.  I have added
> something like that in the patch I have posted today for the custom
> wait events at [1] and it enforces the startup sequences of the
> workers in a stricter way.

Is that very meaningful? ISTM the interesting thing to check for would be that
the state is idle?

Greetings,

Andres Freund



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: Eager page freeze criteria clarification
Next
From: Peter Geoghegan
Date:
Subject: Re: Eager page freeze criteria clarification