Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1o9rNb-0000l9-U1 for pgsql-hackers@arkaria.postgresql.org; Fri, 08 Jul 2022 17:02:59 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1o9rNa-0000d8-L6 for pgsql-hackers@arkaria.postgresql.org; Fri, 08 Jul 2022 17:02:58 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1o9rNa-0000aO-Ba for pgsql-hackers@lists.postgresql.org; Fri, 08 Jul 2022 17:02:58 +0000 Received: from mail.thelabyrinth.net ([45.56.70.56]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1o9rNW-00062F-St for pgsql-hackers@postgresql.org; Fri, 08 Jul 2022 17:02:57 +0000 Received: from [172.20.20.20] (c-24-126-12-96.hsd1.wv.comcast.net [24.126.12.96]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (No client certificate requested) (Authenticated sender: dsteele) by mail.thelabyrinth.net (Postfix) with ESMTPSA id 8028654669; Fri, 8 Jul 2022 17:02:52 +0000 (UTC) Message-ID: <983e1c05-d479-dec3-b96e-0e5e359f5aa7@pgmasters.net> Date: Fri, 8 Jul 2022 13:02:51 -0400 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:91.0) Gecko/20100101 Thunderbird/91.11.0 Subject: Re: remove more archiving overhead Content-Language: en-US To: Nathan Bossart Cc: Kyotaro Horiguchi , robertmhaas@gmail.com, masao.fujii@oss.nttdata.com, pgsql-hackers@postgresql.org References: <20220707182251.GA2255242@nathanxps13> <20220707220716.GA2258527@nathanxps13> <20220708.105652.1551158050191356887.horikyota.ntt@gmail.com> <44dbf5e4-8eec-da56-daba-755128b3723e@pgmasters.net> <20220708165450.GA2356733@nathanxps13> From: David Steele In-Reply-To: <20220708165450.GA2356733@nathanxps13> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 7/8/22 12:54, Nathan Bossart wrote: > On Fri, Jul 08, 2022 at 08:20:09AM -0400, David Steele wrote: > >> Nathan, I don't see the language about being sure to persist to storage >> here? > > It's here: > When an archive library encounters a pre-existing file, it may return > true if the WAL file has identical contents to the pre-existing archive > and the pre-existing archive is fully persisted to storage. > > Since you didn't catch it, I wonder if it needs improvement. At the very > least, perhaps we should note that one way to do the latter is to persist > it yourself before returning true, and we could point to basic_archive.c as > an example. However, I'm hesitant to make these docs too much more > complicated than they already are. WDYT? I think I wrote this before I'd had enough coffee. "fully persisted to storage" can mean many things depending on the storage (Posix, CIFS, S3, etc.) so I think this is fine. The basic_archive module is there for people who would like implementation details for Posix. Regards, -David