Re: Add a GUC check hook to ensure summarize_wal cannot be enabled when wal_level is minimal
От
Nathan Bossart
Тема
Re: Add a GUC check hook to ensure summarize_wal cannot be enabled when wal_level is minimal
Дата
Msg-id
ZpWCJxL3tQm3lkLI@nathan
Ответ на
Re: Add a GUC check hook to ensure summarize_wal cannot be enabled when wal_level is minimal (Robert Haas)
Список
Дерево обсуждения
Add a GUC check hook to ensure summarize_wal cannot be enabled when wal_level is minimal Fujii Masao <masao.fujii@oss.nttdata.com>
Re: Add a GUC check hook to ensure summarize_wal cannot be enabled when wal_level is minimal Robert Haas <robertmhaas@gmail.com>
Re: Add a GUC check hook to ensure summarize_wal cannot be enabled when wal_level is minimal Nathan Bossart <nathandbossart@gmail.com>
Re: Add a GUC check hook to ensure summarize_wal cannot be enabled when wal_level is minimal Daniel Gustafsson <daniel@yesql.se>
Re: Add a GUC check hook to ensure summarize_wal cannot be enabled when wal_level is minimal Tom Lane <tgl@sss.pgh.pa.us>
Re: Add a GUC check hook to ensure summarize_wal cannot be enabled when wal_level is minimal Fujii Masao <masao.fujii@oss.nttdata.com>
Re: Add a GUC check hook to ensure summarize_wal cannot be enabled when wal_level is minimal Robert Haas <robertmhaas@gmail.com>
Re: Add a GUC check hook to ensure summarize_wal cannot be enabled when wal_level is minimal Robert Haas <robertmhaas@gmail.com>
Re: Add a GUC check hook to ensure summarize_wal cannot be enabled when wal_level is minimal Fujii Masao <masao.fujii@oss.nttdata.com>
Re: Add a GUC check hook to ensure summarize_wal cannot be enabled when wal_level is minimal Robert Haas <robertmhaas@gmail.com>
Re: Add a GUC check hook to ensure summarize_wal cannot be enabled when wal_level is minimal Robert Haas <robertmhaas@gmail.com>
Re: Add a GUC check hook to ensure summarize_wal cannot be enabled when wal_level is minimal Fujii Masao <masao.fujii@oss.nttdata.com>
Re: Add a GUC check hook to ensure summarize_wal cannot be enabled when wal_level is minimal Robert Haas <robertmhaas@gmail.com>
Re: Add a GUC check hook to ensure summarize_wal cannot be enabled when wal_level is minimal Fujii Masao <masao.fujii@oss.nttdata.com>
Re: Add a GUC check hook to ensure summarize_wal cannot be enabled when wal_level is minimal Robert Haas <robertmhaas@gmail.com>
Re: Add a GUC check hook to ensure summarize_wal cannot be enabled when wal_level is minimal Nathan Bossart <nathandbossart@gmail.com>
Re: Add a GUC check hook to ensure summarize_wal cannot be enabled when wal_level is minimal Robert Haas <robertmhaas@gmail.com>
Re: Add a GUC check hook to ensure summarize_wal cannot be enabled when wal_level is minimal Nathan Bossart <nathandbossart@gmail.com>
Re: Add a GUC check hook to ensure summarize_wal cannot be enabled when wal_level is minimal Robert Haas <robertmhaas@gmail.com>
Re: Add a GUC check hook to ensure summarize_wal cannot be enabled when wal_level is minimal Nathan Bossart <nathandbossart@gmail.com>
Re: Add a GUC check hook to ensure summarize_wal cannot be enabled when wal_level is minimal Fujii Masao <masao.fujii@oss.nttdata.com>
Re: Add a GUC check hook to ensure summarize_wal cannot be enabled when wal_level is minimal Robert Haas <robertmhaas@gmail.com>
Re: Add a GUC check hook to ensure summarize_wal cannot be enabled when wal_level is minimal Fujii Masao <masao.fujii@oss.nttdata.com>
Re: Add a GUC check hook to ensure summarize_wal cannot be enabled when wal_level is minimal Robert Haas <robertmhaas@gmail.com>
Re: Add a GUC check hook to ensure summarize_wal cannot be enabled when wal_level is minimal Fujii Masao <masao.fujii@oss.nttdata.com>
Re: Add a GUC check hook to ensure summarize_wal cannot be enabled when wal_level is minimal Nathan Bossart <nathandbossart@gmail.com>
Re: Add a GUC check hook to ensure summarize_wal cannot be enabled when wal_level is minimal Robert Haas <robertmhaas@gmail.com>
Re: Add a GUC check hook to ensure summarize_wal cannot be enabled when wal_level is minimal Nathan Bossart <nathandbossart@gmail.com>
Re: Add a GUC check hook to ensure summarize_wal cannot be enabled when wal_level is minimal Fujii Masao <masao.fujii@oss.nttdata.com>
Re: Add a GUC check hook to ensure summarize_wal cannot be enabled when wal_level is minimal Nathan Bossart <nathandbossart@gmail.com>
Re: Add a GUC check hook to ensure summarize_wal cannot be enabled when wal_level is minimal Jelte Fennema-Nio <postgres@jeltef.nl>
Re: Add a GUC check hook to ensure summarize_wal cannot be enabled when wal_level is minimal Tom Lane <tgl@sss.pgh.pa.us>
Re: Add a GUC check hook to ensure summarize_wal cannot be enabled when wal_level is minimal Nathan Bossart <nathandbossart@gmail.com>
Re: Add a GUC check hook to ensure summarize_wal cannot be enabled when wal_level is minimal Tom Lane <tgl@sss.pgh.pa.us>
Re: Add a GUC check hook to ensure summarize_wal cannot be enabled when wal_level is minimal Nathan Bossart <nathandbossart@gmail.com>
Re: Add a GUC check hook to ensure summarize_wal cannot be enabled when wal_level is minimal Fujii Masao <masao.fujii@oss.nttdata.com>
Re: Add a GUC check hook to ensure summarize_wal cannot be enabled when wal_level is minimal Nathan Bossart <nathandbossart@gmail.com>
Re: Add a GUC check hook to ensure summarize_wal cannot be enabled when wal_level is minimal Nathan Bossart <nathandbossart@gmail.com>
Re: Add a GUC check hook to ensure summarize_wal cannot be enabled when wal_level is minimal Tom Lane <tgl@sss.pgh.pa.us>
Re: Add a GUC check hook to ensure summarize_wal cannot be enabled when wal_level is minimal Nathan Bossart <nathandbossart@gmail.com>
Re: Add a GUC check hook to ensure summarize_wal cannot be enabled when wal_level is minimal Jelte Fennema-Nio <postgres@jeltef.nl>
Re: Add a GUC check hook to ensure summarize_wal cannot be enabled when wal_level is minimal Jelte Fennema-Nio <postgres@jeltef.nl>
Re: Add a GUC check hook to ensure summarize_wal cannot be enabled when wal_level is minimal Jelte Fennema-Nio <postgres@jeltef.nl>
Re: Add a GUC check hook to ensure summarize_wal cannot be enabled when wal_level is minimal Jelte Fennema-Nio <postgres@jeltef.nl>
On Mon, Jul 15, 2024 at 04:03:13PM -0400, Robert Haas wrote: > On Mon, Jul 15, 2024 at 2:47 PM Nathan Bossart wrote: >> My understanding is that the correctness of this GUC check hook depends on >> wal_level being a PGC_POSTMASTER GUC. The check hook would always return >> true during startup, and there'd be an additional cross-check in >> PostmasterMain() that would fail startup if necessary. After that point, >> we know that wal_level cannot change, so the GUC check hook for >> summarize_wal can depend on wal_level. If it fails, my expectation would >> be that the server would just ignore that change and continue. > > But how do you know that, during startup, the setting for > summarize_wal is processed after the setting for wal_level? You don't, but the GUC check hook should always return true when summarize_wal is processed first. We'd rely on the PostmasterMain() check to fail in that case. -- nathan
В списке pgsql-hackers по дате отправления
От: Robert Haas
Дата: