RE: New standby_slot_names GUC in PG 17

Поиск
Список
Период
Сортировка
Искать
От
Zhijie Hou (Fujitsu)
Тема
RE: New standby_slot_names GUC in PG 17
Дата
Msg-id
OS0PR01MB5716B4B2CED84C254CA3380E94D52@OS0PR01MB5716.jpnprd01.prod.outlook.com
Ответ на
Список
Дерево обсуждения
New standby_slot_names GUC in PG 17 Bruce Momjian <bruce@momjian.us>
Re: New standby_slot_names GUC in PG 17 Peter Eisentraut <peter@eisentraut.org>
Re: New standby_slot_names GUC in PG 17 Nathan Bossart <nathandbossart@gmail.com>
Re: New standby_slot_names GUC in PG 17 Muhammad Ikram <mmikram@gmail.com>
Re: New standby_slot_names GUC in PG 17 Tom Lane <tgl@sss.pgh.pa.us>
Re: New standby_slot_names GUC in PG 17 Muhammad Ikram <mmikram@gmail.com>
Re: New standby_slot_names GUC in PG 17 Nathan Bossart <nathandbossart@gmail.com>
Re: New standby_slot_names GUC in PG 17 Amit Kapila <amit.kapila16@gmail.com>
RE: New standby_slot_names GUC in PG 17 "Zhijie Hou (Fujitsu)" <houzj.fnst@fujitsu.com>
Re: New standby_slot_names GUC in PG 17 Masahiko Sawada <sawada.mshk@gmail.com>
Re: New standby_slot_names GUC in PG 17 Amit Kapila <amit.kapila16@gmail.com>
Re: New standby_slot_names GUC in PG 17 Masahiko Sawada <sawada.mshk@gmail.com>
Re: New standby_slot_names GUC in PG 17 Amit Kapila <amit.kapila16@gmail.com>
Re: New standby_slot_names GUC in PG 17 Masahiko Sawada <sawada.mshk@gmail.com>
RE: New standby_slot_names GUC in PG 17 "Zhijie Hou (Fujitsu)" <houzj.fnst@fujitsu.com>
Re: New standby_slot_names GUC in PG 17 Bertrand Drouvot <bertranddrouvot.pg@gmail.com>
Re: New standby_slot_names GUC in PG 17 Amit Kapila <amit.kapila16@gmail.com>
Re: New standby_slot_names GUC in PG 17 Michael Paquier <michael@paquier.xyz>
Re: New standby_slot_names GUC in PG 17 Bertrand Drouvot <bertranddrouvot.pg@gmail.com>
RE: New standby_slot_names GUC in PG 17 "Zhijie Hou (Fujitsu)" <houzj.fnst@fujitsu.com>
Re: New standby_slot_names GUC in PG 17 Masahiko Sawada <sawada.mshk@gmail.com>
Re: New standby_slot_names GUC in PG 17 Amit Kapila <amit.kapila16@gmail.com>
RE: New standby_slot_names GUC in PG 17 "Zhijie Hou (Fujitsu)" <houzj.fnst@fujitsu.com>
Re: New standby_slot_names GUC in PG 17 Amit Kapila <amit.kapila16@gmail.com>
Re: New standby_slot_names GUC in PG 17 Bertrand Drouvot <bertranddrouvot.pg@gmail.com>
Re: New standby_slot_names GUC in PG 17 Amit Kapila <amit.kapila16@gmail.com>
Re: New standby_slot_names GUC in PG 17 Nathan Bossart <nathandbossart@gmail.com>
Re: New standby_slot_names GUC in PG 17 Bertrand Drouvot <bertranddrouvot.pg@gmail.com>
Re: New standby_slot_names GUC in PG 17 Bruce Momjian <bruce@momjian.us>
Re: New standby_slot_names GUC in PG 17 Tom Lane <tgl@sss.pgh.pa.us>
Re: New standby_slot_names GUC in PG 17 Amit Kapila <amit.kapila16@gmail.com>
On Saturday, June 22, 2024 5:47 PM Amit Kapila  wrote:
> 
> On Sat, Jun 22, 2024 at 1:49 AM Nathan Bossart
>  wrote:
> >
> > On Fri, Jun 21, 2024 at 03:50:00PM -0400, Tom Lane wrote:
> > >>>>> Allow specification of physical standbys that must be
> > >>>>> synchronized before they are visible to subscribers (Hou Zhijie,
> > >>>>> Shveta Malik)
> > >
> > > it seems like the name ought to have some connection to
> > > synchronization.  Perhaps something like "synchronized_standby_slots"?
> >
> > IMHO that might be a bit too close to synchronous_standby_names.
> >
> 
> Right, but better than the current one. The other possibility could be
> wait_for_standby_slots.

I agree the current name seems too generic and the suggested ' synchronized_standby_slots '
is better than the current one.

Some other ideas could be:

synchronize_slots_on_standbys: it indicates that the standbys that enabled
slot sync should be listed in this GUC.

logical_replication_wait_slots: it means the logical replication(logical
Walsender process) will wait for these slots to advance the confirm flush
lsn before proceeding.

Best Regards,
Hou zj
В списке pgsql-hackers по дате отправления
От: Tom Lane
Дата:
От: Noah Misch
Дата:
Сообщение: Re: Injection point locking
FAQ