Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hGFEW-0002CQ-6M for pgsql-hackers@arkaria.postgresql.org; Tue, 16 Apr 2019 03:58:08 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hGFEU-0007fq-Im for pgsql-hackers@arkaria.postgresql.org; Tue, 16 Apr 2019 03:58:06 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hGFEU-0007fB-9U for pgsql-hackers@lists.postgresql.org; Tue, 16 Apr 2019 03:58:06 +0000 Received: from wout4-smtp.messagingengine.com ([64.147.123.20]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hGFER-0001qJ-PE for pgsql-hackers@postgresql.org; Tue, 16 Apr 2019 03:58:05 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.west.internal (Postfix) with ESMTP id 5EF2465C; Mon, 15 Apr 2019 23:58:01 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute4.internal (MEProxy); Mon, 15 Apr 2019 23:58:01 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= date:from:to:cc:subject:message-id:references:mime-version :content-type:in-reply-to; s=fm1; bh=zBvda3b1azqdaaD/Y0w7D4uNlPc UXnUJ+eJQrCAxdME=; b=B1mnHrDyWm5mv99e/gSjuuj6nX0cR+PKy+J7AO/Bnxq gZLttTBnkYZVZakSUfYGUT/2A4gpQBIZWla9JoDdXfBSddiB0xOjqdDzZ9QGM6YA Zp7TWyB6gG1+HDdUENsobIeidFdYuWcxTnptZHAxFfnB4V8xgnWCFrzQobubcdUh MHKiyKt5mm/I8TB0QYtN3aLnSt4bsy3loCWJ34LS5kQH9P/hL4eAI9BHUdCdRCKa oVg/a7ndL9IxuHNFpFtWe5nVLtmcqt3lut/DZ1Kdh9rkyj2dDFeP4cnYPRYN+oce LgxVMXs4KJYwvrtFzgtDGDi7kUzen7v6JTXakMYkMtQ== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-me-proxy :x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm2; bh=zBvda3 b1azqdaaD/Y0w7D4uNlPcUXnUJ+eJQrCAxdME=; b=4R40EYUGGRGLC0PwGf1/S7 F29t7PMc/v2wzu8ZiDTBRIS12/W20qdmLrWuOjM2cUBBnv40RXyx+xS04CNJNAYN 2mY9XmPqIvVEjUEkG3U4JYunPtTB+wJeqOrYVzq2tkSho4qRIygsBoLlvwigL38Z Aui4HIOsrl7xcYBRW8z37gyBrq5c0rZm4r8ZZbg5FP5h2MuHwj62tnQkiJPs/PkA 6aKVU9PPRoBG4yMtK2JEKcilroeMxvuZHLg4whQo2rosXZwYtcKDY1p0IzXLoBYy dn1wisWgnI/7awKV4e1fMp0vPlAaqLXeaiWz6RbET9dmpsxzWVeK49PDveaASh2g == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeduuddrfedtgdejiecutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenfg hrlhcuvffnffculdejtddmnecujfgurhepfffhvffukfhfgggtuggjsehgtderredttddv necuhfhrohhmpefoihgthhgrvghlucfrrghquhhivghruceomhhitghhrggvlhesphgrqh huihgvrhdrgiihiieqnecukfhppeduuddurddutddvrddukedtrddukeehnecurfgrrhgr mhepmhgrihhlfhhrohhmpehmihgthhgrvghlsehprghquhhivghrrdighiiinecuvehluh hsthgvrhfuihiivgeptd X-ME-Proxy: Received: from paquier.xyz (ee0822lan1.rev.em-net.ne.jp [111.102.180.185]) by mail.messagingengine.com (Postfix) with ESMTPA id A6838E44F1; Mon, 15 Apr 2019 23:57:57 -0400 (EDT) Date: Tue, 16 Apr 2019 12:57:53 +0900 From: Michael Paquier To: Tom Lane Cc: Robert Haas , Masahiko Sawada , Kyotaro HORIGUCHI , "Bossart, Nathan" , Alvaro Herrera , PostgreSQL-development Subject: Re: New vacuum option to do only freezing Message-ID: <20190416035753.GD2673@paquier.xyz> References: <15751.1555256860@sss.pgh.pa.us> <16814.1555348381@sss.pgh.pa.us> <23885.1555357618@sss.pgh.pa.us> <28991.1555376836@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="UfEAyuTBtIjiZzX6" Content-Disposition: inline In-Reply-To: <28991.1555376836@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --UfEAyuTBtIjiZzX6 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Mon, Apr 15, 2019 at 09:07:16PM -0400, Tom Lane wrote: > If we're failing to remove it, and it's below the desired freeze > horizon, then we'd darn well better freeze it instead, no? >=20 > Since we know that the tuple only just became dead, I suspect > that the case would be unreachable in practice. But the approach > you propose risks violating the invariant that all old tuples > will either be removed or frozen. Please note that I have added an open item for this investigation (see "topminnow triggered assertion failure with vacuum_index_cleanup"). -- Michael --UfEAyuTBtIjiZzX6 Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAly1UsEACgkQnvQgOdby QH2JEA/9G8vC1LTaKQKGcU9Yde/epsba3qwBSvZUHjEb1UXWsHJDhyCNxOlsLtcw IC1c3gkcwR4ruJohw2C8NwucKiS86ZpJ55LnKb+dc31RzhU/Y1cHlHKQOKrhO3gH XYLeYlhFnCo/B0PFs+pKG9VoHz+qPZAnY77vs9ot36jJV466NZdnISN2eg3PC0Pb 1RhtYRMvovNxNZH4y4sBh86bO5TxEUjFTxDBHdjHSxd+2gVVJbjhN09p4Civqj3y YYq8kw6mi+Yc07//QMku4wgtaTwB7QFL/JLUXB3hwq90H4Uokj5DCcY7jTda6mXM 2bQNlEFRL/k0vQj+MipL08I0GJQEkJJ1lKNZhSf4ID/IoAYoTXJGaGACK7Z8nsCo LN45E33Rc/aMVeHbuuSy55xKPsTBQXOLq/3gZsvCw6zkhYJRgO7VVZPTjAFwvuFV zkjQf2DtwnYLx6NtJJ/7bLq3eHDa919rtpO59FQaA1mzoOxswTsxqOlmo3/Qopy5 Bs7kSlSi8YbWa9Fyq3g7Ez0ldST53q/xRGZHENwHFL3Qoor9OYBYJilND7rF0YDp C/nvtBdcQvSI9fnbG7MgIbfSfBg92sTwHMBwXKMsd8UwlAjEF1wAg+rYEP0WnMQW Y1PjJckM8fGRZI0SdQoYBG48skidiKgsHdptmwZX8Id38umnbM8= =by2k -----END PGP SIGNATURE----- --UfEAyuTBtIjiZzX6--