Re: Document default values for pgoutput options + fix missing initialization for "origin" - Mailing list pgsql-hackers

From Fujii Masao
Subject Re: Document default values for pgoutput options + fix missing initialization for "origin"
Date
Msg-id 5a01bf06-d3d2-49f5-bc94-0a1b6990320f@oss.nttdata.com
Whole thread Raw
In response to Re: Document default values for pgoutput options + fix missing initialization for "origin"  (Amit Kapila <amit.kapila16@gmail.com>)
List pgsql-hackers

On 2025/05/20 13:09, Amit Kapila wrote:
>> +       Option to enable streaming of in-progress transactions. Valid values are
>> +       <literal>off</literal> (the default), <literal>on</literal> and
>> +       <literal>parallel</literal>. The setting <literal>parallel</literal>
>> +       enables sending extra information with some messages to be used for
>> +       parallelization. Minimum protocol version 2 is required to turn it
>> +       <literal>on</literal>.  Minimum protocol version 4 is required for the
>> +       <literal>parallel</literal> value.
>>
> 
> One point to note about this is that we change the default value for
> the streaming option to parallel for a subscription in the commit
> 1bf1140be8. But pgoutput still considers the default value to be off.
> I thought about this, but not sure if there is any clear value in
> changing the default of pgoutput. Would you have any thoughts on the
> same?

Using "off" as the pgoutput's default seems better to me,
since it works regardless of protocol version.

Regards,

-- 
Fujii Masao
Advanced Computing Technology Center
Research and Development Headquarters
NTT DATA CORPORATION




pgsql-hackers by date:

Previous
From: Daniel Gustafsson
Date:
Subject: Re: Addition of %b/backend_type in log_line_prefix of TAP test logs
Next
From: Laurenz Albe
Date:
Subject: Re: Disable parallel query by default