pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Fujii Masao <masao.fujii@oss.nttdata.com>
To: Robert Haas <robertmhaas@gmail.com>
Cc: Nathan Bossart <nathandbossart@gmail.com>
Cc: pgsql-hackers@lists.postgresql.org
Subject: Re: Add a GUC check hook to ensure summarize_wal cannot be enabled when wal_level is minimal
Date: Thu, 18 Jul 2024 22:47:16 +0900
Message-ID: <6b210ab2-750c-41fd-8954-d5fd0f1d4437@oss.nttdata.com> (raw)
In-Reply-To: <CA+Tgmob6MSyKPQQ2QfKVznLHz1-Dg2AoZxjUoz80PTYXq14gRw@mail.gmail.com>
References: <CA+TgmoansG0B8ayQGw9Ozee6Jawz=HFUACpO_4gp-+SFJBxiYw@mail.gmail.com>
	<CA+TgmoZ53ADUm2UAGEspMuv-Db5SGtrOXUx=ps6LcGexsf5-fA@mail.gmail.com>
	<e2549085-5246-4edc-bc62-ae19df48acc5@oss.nttdata.com>
	<CA+TgmoYFOWbxk=FP+ZnxwVaKQEce=+0Xvzh0DUC9=YLNHiQW1w@mail.gmail.com>
	<8a668c51-c6af-4744-a978-c6a2ce3b1d83@oss.nttdata.com>
	<CA+TgmoYUhRa8j8_Jdrb9Ankz=c8NRLe_x1nf4L+Vc2V+DiTSWw@mail.gmail.com>
	<ZpVushkGx0_nYIip@nathan>
	<CA+TgmoaKqLrkjEg1j6NEHcMUj-Qk6yUK=qfFzy+G-w6OVVv+0Q@mail.gmail.com>
	<ZpWCJxL3tQm3lkLI@nathan>
	<CA+TgmobLzdVQCjy9abec-UFrN1SmwHGv9WcaOD_XixmJN5e+=A@mail.gmail.com>
	<ZpagGUyMkwg-LeKC@nathan>
	<22585eb0-4a10-4d99-9914-bdee011e8778@oss.nttdata.com>
	<CA+Tgmob6MSyKPQQ2QfKVznLHz1-Dg2AoZxjUoz80PTYXq14gRw@mail.gmail.com>



On 2024/07/17 22:44, Robert Haas wrote:
> On Tue, Jul 16, 2024 at 1:16 PM Fujii Masao <masao.fujii@oss.nttdata.com> wrote:
>> I don't have another solution that can be pushed into v17. I understand
>> the risks raised so far, so I'm okay with just pushing the "fast_forward" patch.
>> It might be helpful to add a note to the summarize_wal documentation,
>> for example, "summarize_wal can be enabled after startup with wal_level = minimal,
>> but WAL generated at this level won't be summarized."?
> 
> Here is v5. This version differs from v4 in that it updates the
> documentation for summarize_wal and pg_get_wal_summarizer_state(). The
> previous version made no documentation changes.

Thanks for updating the patch! It looks good to me, except for one minor detail.

> +        reaches WAL not generated under <literal>wal_level=minimal</literal>,
> +        it will resume writing summaries to disk.

"WAL not generated under wal_level=minimal" sounds a bit confusing??
How about "WAL generated while wal_level is replica or higher" instead?

Regards,

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





view thread (44+ messages)  latest in thread

Message-ID: <6b210ab2-750c-41fd-8954-d5fd0f1d4437@oss.nttdata.com>
Permalink:  ../6b210ab2-750c-41fd-8954-d5fd0f1d4437@oss.nttdata.com/
Also on:    postgresql.org/message-id/6b210ab2-750c-41fd-8954-d5fd0f1d4437@oss.nttdata.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-hackers@postgresql.org
  Cc: masao.fujii@oss.nttdata.com, robertmhaas@gmail.com, nathandbossart@gmail.com, pgsql-hackers@lists.postgresql.org
  Subject: Re: Add a GUC check hook to ensure summarize_wal cannot be enabled when wal_level is minimal
  In-Reply-To: <6b210ab2-750c-41fd-8954-d5fd0f1d4437@oss.nttdata.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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