pg.ddx.io pgsql-committers@postgresql.org mailing list archivehelp / color / mirror / Atom feed
pgsql: Change the default value of the streaming option to 'parallel'. 2+ messages / 2 participants [nested] [flat]
* pgsql: Change the default value of the streaming option to 'parallel'. @ 2024-10-28 03:25 Amit Kapila <akapila@postgresql.org> 0 siblings, 1 reply; 2+ messages in thread From: Amit Kapila @ 2024-10-28 03:25 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Change the default value of the streaming option to 'parallel'. Previously the default value of streaming option for a subscription was 'off'. The parallel option indicates that the changes in large transactions (greater than logical_decoding_work_mem) are to be applied directly via one of the parallel apply workers, if available. The parallel mode was introduced in 16, but we refrain from enabling it by default to avoid seeing any unpleasant behavior in the existing applications. However we haven't found any such report yet, so this is a good time to enable it by default. Reported-by: Vignesh C Author: Hayato Kuroda, Masahiko Sawada, Peter Smith, Amit Kapila Discussion: https://postgr.es/m/CALDaNm1=MedhW23NuoePJTmonwsMSp80ddsw+sEJs0GUMC_kqQ@mail.gmail.com Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/1bf1140be87230c71d0e7b29939f7e2b3d073aa1 Modified Files -------------- doc/src/sgml/ref/create_subscription.sgml | 27 ++++++++++++++++--------- src/backend/commands/subscriptioncmds.c | 2 +- src/bin/pg_dump/pg_dump.c | 2 ++ src/bin/pg_dump/t/002_pg_dump.pl | 10 ++++----- src/test/regress/expected/subscription.out | 24 +++++++++++----------- src/test/subscription/t/022_twophase_cascade.pl | 4 ++-- 6 files changed, 39 insertions(+), 30 deletions(-) ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: pgsql: Change the default value of the streaming option to 'parallel'. @ 2024-10-29 04:05 Amit Kapila <amit.kapila16@gmail.com> parent: Amit Kapila <akapila@postgresql.org> 0 siblings, 0 replies; 2+ messages in thread From: Amit Kapila @ 2024-10-29 04:05 UTC (permalink / raw) To: Amit Kapila <akapila@postgresql.org>; +Cc: pgsql-committers@lists.postgresql.org On Mon, Oct 28, 2024 at 8:55 AM Amit Kapila <akapila@postgresql.org> wrote: > > Change the default value of the streaming option to 'parallel'. ... > > Reported-by: Vignesh C > Author: Hayato Kuroda, Masahiko Sawada, Peter Smith, Amit Kapila > Discussion: https://postgr.es/m/CALDaNm1=MedhW23NuoePJTmonwsMSp80ddsw+sEJs0GUMC_kqQ@mail.gmail.com > I have made a mistake in giving credits for the patch. It should be as follows: Author: Vignesh C Reviewed-by: Hayato Kuroda, Masahiko Sawada, Peter Smith, Amit Kapila Sorry for the mistake. -- With Regards, Amit Kapila. ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2024-10-29 04:05 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2024-10-28 03:25 pgsql: Change the default value of the streaming option to 'parallel'. Amit Kapila <akapila@postgresql.org> 2024-10-29 04:05 ` Amit Kapila <amit.kapila16@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox