Re: issue with synchronized_standby_slots

From: Rahila Syed <rahilasyed90(at)gmail(dot)com>
To: Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>
Cc: Alexander Kukushkin <cyberdemn(at)gmail(dot)com>, Shlok Kyal <shlok(dot)kyal(dot)oss(at)gmail(dot)com>, Fabrice Chapuis <fabrice636861(at)gmail(dot)com>, "Zhijie Hou (Fujitsu)" <houzj(dot)fnst(at)fujitsu(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: issue with synchronized_standby_slots
Date: 2025-09-11 06:30:20
Message-ID: CAH2L28to=MUEGDmVJL6Ph5By8gkUMkBmH-rhhgk+BeWbMoB_QQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

>
> BTW, we should also try to conclude on my yesterday's point as to why
> it is okay to have the same behavior for default_tablespace and
> default_table_access_method and not for this parameter? I am asking
> because if we change the current behavior, tomorrow, we can get
> complaints that one expects the old behaviour as that was similar to
> other GUCs like default_tablespace and default_table_access_method.
>
>
Fair point. I haven't examined the validation of GUCs in parallel workers
closely,
but one argument for preventing parallel workers from failing due to an
incorrect
value of synchronized_standby_slots is that a select query works in this
situation
without parallel workers.

Whereas, for incorrect values of default_tablespace and
default_table_access_method,
most commands would fail regardless of whether parallel workers are enabled.

PFA a test for the original bug report on this thread. This applies on the
v3 version of the patch
that was shared.

Thank you,
Rahila Syed

Attachment Content-Type Size
0001-Add-a-test-for-a-disabled-GUC-check-for-parallel-wor.patch application/octet-stream 1.6 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Amit Kapila 2025-09-11 06:32:12 Re: POC: enable logical decoding when wal_level = 'replica' without a server restart
Previous Message 李海洋 (陌痕) 2025-09-11 06:23:31 回复:someone else to do the list of acknowledgments