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 1m9fVi-0005Cw-Dp for pgsql-hackers@arkaria.postgresql.org; Sat, 31 Jul 2021 03:18:02 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1m9fVh-00007n-4j for pgsql-hackers@arkaria.postgresql.org; Sat, 31 Jul 2021 03:18:01 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1m9fVg-00007e-AJ for pgsql-hackers@lists.postgresql.org; Sat, 31 Jul 2021 03:18:00 +0000 Received: from wout4-smtp.messagingengine.com ([64.147.123.20]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1m9fVd-0007Le-Qg for pgsql-hackers@postgresql.org; Sat, 31 Jul 2021 03:17:59 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.west.internal (Postfix) with ESMTP id CB810320077A; Fri, 30 Jul 2021 23:17:54 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute4.internal (MEProxy); Fri, 30 Jul 2021 23:17:55 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-transfer-encoding:content-type :date:from:in-reply-to:message-id:mime-version:subject:to :x-me-proxy:x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s= fm3; bh=oKHPWjZqOJkYiZKplwSqrF0voE+tmnsl6sQHkbGRqAM=; b=bZ4nNqqS 836PVgDn9boiA8t0J0EVvlSJREHsD3tX0KtW4bbByVKZaIBnUOn7jQj7wuybtHzu YFmXTb2QGQI0oxwlAwhJESXPjp4lVmg58T53l6xcMRmnUjibRNshvXNVZtrLF2hQ g3FSU3DxPnDCRoEfMa0VsxeQqcGEXgz1yaFU/T1xTGqT0ysyBftjDNapb8DgvINt 10WwEcI6JdqMkIyHItyi4JmuF92NwSUr+pd6IjHnpy/OovNiqFmm6/Q1Z+LDi+g7 F7xIHnf1UcmN01lFmzuMpA3MsQ+gkjAyVk73/GH5rHxjj5WKvODe18h6BsGL0int UXF9bckoc3InRg== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvtddrheeigdeijecutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenuc fjughrpeffhffvuffkgggtugfgjgesthekredttddtjeenucfhrhhomheptehlvhgrrhho ucfjvghrrhgvrhgruceorghlvhhhvghrrhgvsegrlhhvhhdrnhhoqdhiphdrohhrgheqne cuggftrfgrthhtvghrnhepfeduleekteeigfegledtvddvvddtledugfefhfdtieevteef tdeuueehudeuvdelnecuffhomhgrihhnpegvnhhtvghrphhrihhsvggusgdrtghomhdpph hoshhtghhrvghsqhhlrdhorhhgnecuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghm pehmrghilhhfrhhomheprghlvhhhvghrrhgvsegrlhhvhhdrnhhoqdhiphdrohhrgh X-ME-Proxy: Received: by mail.messagingengine.com (Postfix) with ESMTPA; Fri, 30 Jul 2021 23:17:53 -0400 (EDT) Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000) id C2CD42A092C; Fri, 30 Jul 2021 23:17:49 -0400 (-04) Date: Fri, 30 Jul 2021 23:17:49 -0400 From: Alvaro Herrera To: "Bossart, Nathan" Cc: Kyotaro Horiguchi , "x4mmm@yandex-team.ru" , "a.lubennikova@postgrespro.ru" , "hlinnaka@iki.fi" , "matsumura.ryo@fujitsu.com" , "masao.fujii@gmail.com" , "pgsql-hackers@postgresql.org" Subject: Re: archive status ".ready" files may be created too early Message-ID: <202107310317.54wstcc3b27p@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <202107302351.zovw4tdoe47e@alvherre.pgsql> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 2021-Jul-30, Alvaro Herrera wrote: > We set archiver's latch on each XLogArchiveNotify(), but if we're doing > it in a loop such as in NotifySegmentsReadyForArchive() perhaps it is > better to create all the .ready files first and do PgArchWakeup() at the > end. I'm not convinced that this is useful but let's at least discard > the idea explicitly if not. hm, this causes an ABI change so it's not backpatchable. -- Álvaro Herrera 39°49'30"S 73°17'W — https://www.EnterpriseDB.com/ "This is what I like so much about PostgreSQL. Most of the surprises are of the "oh wow! That's cool" Not the "oh shit!" kind. :)" Scott Marlowe, http://archives.postgresql.org/pgsql-admin/2008-10/msg00152.php