RE: Connection limits/permissions, slotsync workers, etc - Mailing list pgsql-hackers

From Zhijie Hou (Fujitsu)
Subject RE: Connection limits/permissions, slotsync workers, etc
Date
Msg-id OS0PR01MB57164D50374ABD05229807B0940F2@OS0PR01MB5716.jpnprd01.prod.outlook.com
Whole thread Raw
In response to Re: Connection limits/permissions, slotsync workers, etc  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Connection limits/permissions, slotsync workers, etc
List pgsql-hackers
On Saturday, December 28, 2024 1:31 AM Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> "Zhijie Hou (Fujitsu)" <houzj.fnst@fujitsu.com> writes:
> > On Thursday, December 26, 2024 3:50 AM Tom Lane <tgl@sss.pgh.pa.us>
> >> I wonder if the AV launcher and slotsync worker could be reclassified
> >> as "auxiliary processes" instead of being their own weird animal.
>
> > It appears that the current aux processes do not run transactions as
> > stated in the comments[1], so we may need to somehow release this
> > restriction to achieve the goal.
>
> Ah, right, I'd forgotten about that restriction.  I agree that removing it wouldn't
> be very reasonable.  However, I still would rather avoid making the slotsync
> worker be its very own special snowflake, because that offers no support for
> the next person who wants to invent a new sort of specialized
> transaction-capable process.
>
> Attached is an alternative proposal that groups the autovac launcher and
> slotsync worker into a new category of "special workers" (better name
> welcome).  I chose to put them into the existing autovacFreeProcs freelist,
> partly because the autovac launcher lives there already but mostly because I
> don't want to add another freelist in a patch we need to put into v17.  (As
> written, your patch is an ABI break.

Right, thanks for pointing it out. The new version patch looks good to me.

Best Regards,
Hou zj




pgsql-hackers by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: Add the ability to limit the amount of memory that can be allocated to backends.
Next
From: Sami Imseih
Date:
Subject: Re: Logging parallel worker draught