Re: Make default subscription streaming option as Parallel - Mailing list pgsql-hackers

From shveta malik
Subject Re: Make default subscription streaming option as Parallel
Date
Msg-id CAJpy0uAEiWXaakSqhwS2cyH2e_WDBGG+XSrsKTvTzm5P6+WmJA@mail.gmail.com
Whole thread Raw
In response to Re: Make default subscription streaming option as Parallel  (Amit Kapila <amit.kapila16@gmail.com>)
List pgsql-hackers
On Tue, Oct 8, 2024 at 3:38 PM Amit Kapila <amit.kapila16@gmail.com> wrote:
>
> On Tue, Oct 8, 2024 at 2:25 PM shveta malik <shveta.malik@gmail.com> wrote:
> >
> > On Mon, Oct 7, 2024 at 4:03 PM vignesh C <vignesh21@gmail.com> wrote:
> > >
> >
> > With parallel streaming as default, do you think there is a need to
> > increase the default for 'max_logical_replication_workers' as IIUC
> > parallel workers are taken from the same pool.
> >
>
> Good question. But then one may say that we should proportionately
> increase max_worker_processes as well. I don't know what should be
> reasonable new defaults.

Agreed on the same query on the next level of max_worker_processes .

> I think we should make parallel streaming as
> default and then wait for some user feedback before changing other
> defaults.
>

Okay, sounds good to me. It is not a blocking factor anyway, user can
always change it to a higher value in case his requirement is like
that.

thanks
Shveta



pgsql-hackers by date:

Previous
From: Antonin Houska
Date:
Subject: Re: [PoC] Federated Authn/z with OAUTHBEARER
Next
From: Yugo NAGATA
Date:
Subject: Re: First draft of PG 17 release notes