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 1nAJPn-0003Lu-Pj for pgsql-hackers@arkaria.postgresql.org; Wed, 19 Jan 2022 22:26:52 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nAJPm-0006Wb-DX for pgsql-hackers@arkaria.postgresql.org; Wed, 19 Jan 2022 22:26:50 +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 1nAJPk-0006WJ-Ur for pgsql-hackers@lists.postgresql.org; Wed, 19 Jan 2022 22:26:50 +0000 Received: from wout1-smtp.messagingengine.com ([64.147.123.24]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nAJPe-000123-1O for pgsql-hackers@lists.postgresql.org; Wed, 19 Jan 2022 22:26:47 +0000 Received: from compute2.internal (compute2.nyi.internal [10.202.2.46]) by mailout.west.internal (Postfix) with ESMTP id 9EC7B3200E82; Wed, 19 Jan 2022 17:26:39 -0500 (EST) Received: from mailfrontend2 ([10.202.2.163]) by compute2.internal (MEProxy); Wed, 19 Jan 2022 17:26:40 -0500 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=fm3; bh=un799YIY2rbB9cqucdYjbLyG7IE zzSeiaSv9193+OXQ=; b=eOrT/jWOODcufA+xmSH2ihXhcuzHE/GvDBUI7V8j2wu tXeLFf+vU6QZV9CMPNZ8kMSyGNjkjij/iqJ6WWHZgctU1TMJUlG6mpJRKOdaTLWa RXC4ke2FJMobkI4NyRSDcvzuRh2OuIgG2ZDam5O1v3X/B/YgHAQW0pXK0q8qiEFm RVl22nlumEVHGRfPqVZbdim17omOztyWU7ioTrk7l39qa/eDJMz2One/i1qmpy7+ EPH6zX/ThXQfDWhSWITx6fvHM0amqOvJkfqgrMWi12MXwjEO/dTiu9K4JlmRbqPa 0nvr7zqVrhsv2dunaV9zAuNYHO/HXdgpUgTV02eQM+g== 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=fm1; bh=un799Y IY2rbB9cqucdYjbLyG7IEzzSeiaSv9193+OXQ=; b=NM32irT1Jiay7S8wpxOY3I YpWMXQNxrPFFpUQT95tNe6X40uEkp4vkSbkthINdphlGqwMGVD7nDTFFDXt8sy1r 0ZZp7SMHxxpfhdjuccDfQWYo1B5KNNtKGa8pn4P0KPfu4bArf6aDUrxbYCOj/l9T xaHNvaNFVo80Twv+k5CR3J8El1xfF5z/RC4nwWUx+0DWjVa6cg9r4At6ilWuCoZT yCajiRLFLTgCW/SgqZMJPLN0Gyncg46gBaTLOxJrJ4gM4uxVaZByQ1u+2g9GpNog CZwXVjfFVBTml0Q+7dXiExEgYsDfDEf+vYpKC0g8DJ6386J7G26QGFwmsJjk5P1A == X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvvddrudeigddutddvucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne gfrhhlucfvnfffucdljedtmdenucfjughrpeffhffvuffkfhggtggujgesghdtreertddt vdenucfhrhhomhepofhitghhrggvlhcurfgrqhhuihgvrhcuoehmihgthhgrvghlsehprg hquhhivghrrdighiiiqeenucggtffrrghtthgvrhhnpedvgeduuefhtdeuleettdevjeeh heeiveeuieegleetgeeljeelieeuieehgeevhfenucevlhhushhtvghrufhiiigvpedtne curfgrrhgrmhepmhgrihhlfhhrohhmpehmihgthhgrvghlsehprghquhhivghrrdighiii X-ME-Proxy: Received: by mail.messagingengine.com (Postfix) with ESMTPA; Wed, 19 Jan 2022 17:26:37 -0500 (EST) Date: Thu, 20 Jan 2022 07:26:32 +0900 From: Michael Paquier To: "Bossart, Nathan" Cc: John Naylor , Masahiko Sawada , Peter Geoghegan , Andres Freund , PostgreSQL Hackers Subject: Re: do only critical work during single-user vacuum? Message-ID: References: <8274EAFF-2E66-41D6-8F7E-A7E4A8E9A0A3@amazon.com> <2E490EFA-541B-44BA-84CB-8229E304188B@amazon.com> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="W2lNStEK/mMLIgOT" Content-Disposition: inline In-Reply-To: <2E490EFA-541B-44BA-84CB-8229E304188B@amazon.com> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --W2lNStEK/mMLIgOT Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Wed, Jan 19, 2022 at 09:11:48PM +0000, Bossart, Nathan wrote: > I personally think VACUUM FOR WRAPAROUND is the best of the options > provided thus far. Could you avoid introducing a new grammar pattern in VACUUM? Any new option had better be within the parenthesized part as it is extensible at will with its set of DefElems. -- Michael --W2lNStEK/mMLIgOT Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmHokBgACgkQnvQgOdby QH3Gsg//SVzLtPxPCREUCNBr9hlPerbkeniOUNd031j77VsToA/LK8Oc2vYLs273 0F0mj+9mQwuMDcgXouv03lZdDbpgQeiDOORwJxeNmUw3WsHoHr3OH40TgWXSkJb2 q3BwmV1utv/O2ylqKuTap99jHm8KL3sShL0P+nwIYcZFUtZVOTGlhKvEmla3hUZU vOMI19OrXUGhkrPfbjr7g6T4fQfCMi7IEfUATvzu2re22PBonH6yeNG57iG4PcPV IPVBF5WnedG5hi0XPTF7AY5+WfdaOyOCPZlLTnCS9FFbXEAx/dxVjRMMdx+grGMh Xlzpeptg8YAyaSak8mlCGOxig3ChgNrfHpe1tsEsIcXtPBwnxFk/oGMqYVAIcxrZ mLuW5Hok0JRzzE097C2J4shLqE8Uzqwl7plxagp0+f+3Y30fYjgIUeYYIcDQvnFK PyrFJFbL6EhSZ6tSy04eRcVS5ORGAwSx0BVbSxDMgsu8fXIqRqkda+uP2GsK9Itc Olwd4OUAtxQiA5rwd0rIwR3lYKRv5BlxLkDYJtxTNxRTIR5wCUTKmW4VVtHfmQLy Ew3wjtTknOlYAi5x9k0iOA45bemjoiQ6Mt0IyDXbvjoAlFNdH+nw3JEXU09BiJ9Z dJA6n0QOyW5O1WzCZB8q4eE/hmBSxs2rnlzTOmi/VpURkRKU5NM= =cRvZ -----END PGP SIGNATURE----- --W2lNStEK/mMLIgOT--