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

From Dilip Kumar
Subject Re: Make default subscription streaming option as Parallel
Date
Msg-id CAFiTN-umjpfJsp8tzTtjOSiodDXUxe6kP3nKTqQsdjoCEnHygw@mail.gmail.com
Whole thread Raw
In response to Re: Make default subscription streaming option as Parallel  (Amit Kapila <amit.kapila16@gmail.com>)
Responses Re: Make default subscription streaming option as Parallel
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. I think we should make parallel streaming as
default and then wait for some user feedback before changing other
defaults.


I agree, actually streaming of in progress transactions is a useful feature for performance in case of large transactions, so it makes sense to make it "on" by default.  So +1 from my side.


--
Regards,
Dilip Kumar
EnterpriseDB: http://www.enterprisedb.com

pgsql-hackers by date:

Previous
From: Tatsuo Ishii
Date:
Subject: Re: Enhance create subscription reference manual
Next
From: Fujii Masao
Date:
Subject: Re: Add “FOR UPDATE NOWAIT” lock details to the log.