Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sURTj-0034Pz-2O for pgsql-hackers@arkaria.postgresql.org; Thu, 18 Jul 2024 13:47:26 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sURTg-00Gb4I-Ok for pgsql-hackers@arkaria.postgresql.org; Thu, 18 Jul 2024 13:47:25 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sURTg-00Gb1c-Ec for pgsql-hackers@lists.postgresql.org; Thu, 18 Jul 2024 13:47:24 +0000 Received: from oss.nttdata.com ([49.212.34.109]) by makus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sURTd-000CPL-Ea for pgsql-hackers@lists.postgresql.org; Thu, 18 Jul 2024 13:47:23 +0000 Received: from [192.168.11.3] (p4227034-ipxg13801funabasi.chiba.ocn.ne.jp [122.26.176.34]) by oss.nttdata.com (Postfix) with ESMTPSA id 0AAAD619B9; Thu, 18 Jul 2024 22:47:17 +0900 (JST) X-Virus-Status: Clean X-Virus-Scanned: clamav-milter 0.103.11 at oss.nttdata.com Message-ID: <6b210ab2-750c-41fd-8954-d5fd0f1d4437@oss.nttdata.com> Date: Thu, 18 Jul 2024 22:47:16 +0900 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Add a GUC check hook to ensure summarize_wal cannot be enabled when wal_level is minimal To: Robert Haas Cc: Nathan Bossart , pgsql-hackers@lists.postgresql.org References: <8a668c51-c6af-4744-a978-c6a2ce3b1d83@oss.nttdata.com> <22585eb0-4a10-4d99-9914-bdee011e8778@oss.nttdata.com> Content-Language: en-US From: Fujii Masao In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 2024/07/17 22:44, Robert Haas wrote: > On Tue, Jul 16, 2024 at 1:16 PM Fujii Masao 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 wal_level=minimal, > + 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