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-vnkJ85NXUcU5Cc9xBpYcvTT0Axjr4ZTjHkGo+a22Kh4Q@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 Fri, 18 Oct 2024 at 5:24 PM, Amit Kapila <amit.kapila16@gmail.com> wrote:
On Fri, Oct 18, 2024 at 9:48 AM Dilip Kumar <dilipbalaut@gmail.com> wrote:
>
> 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.
>

Your response is confusing. AFAIU, this proposal is to change the
default value of the streaming option to 'parallel' but you are
suggesting to make 'on' as default which is different from the
proposed default but OTOH you are saying +1 as well. So, both can't be
true.

Sorry for confusion I meant to say change default as ‘parallel’

Dilip

pgsql-hackers by date:

Previous
From: jian he
Date:
Subject: Re: New "raw" COPY format
Next
From: Junwang Zhao
Date:
Subject: Re: Using read_stream in index vacuum