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 1upp9D-00CgTl-C6 for pgsql-hackers@arkaria.postgresql.org; Sat, 23 Aug 2025 14:23:12 +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 1upp9C-00F4FO-Lp for pgsql-hackers@arkaria.postgresql.org; Sat, 23 Aug 2025 14:23:11 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1upp9C-00F4FG-4v for pgsql-hackers@lists.postgresql.org; Sat, 23 Aug 2025 14:23:11 +0000 Received: from fout-b5-smtp.messagingengine.com ([202.12.124.148]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1upp9A-001S3u-0R for pgsql-hackers@lists.postgresql.org; Sat, 23 Aug 2025 14:23:10 +0000 Received: from phl-compute-04.internal (phl-compute-04.internal [10.202.2.44]) by mailfout.stl.internal (Postfix) with ESMTP id 4D8461D0007C; Sat, 23 Aug 2025 10:23:06 -0400 (EDT) Received: from phl-imap-17 ([10.202.2.105]) by phl-compute-04.internal (MEProxy); Sat, 23 Aug 2025 10:23:06 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=kurilemu.de; h= cc:cc:content-transfer-encoding:content-type:content-type:date :date:from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to; s=fm2; t=1755958986; x=1756045386; bh=uodYYLMRFoPljHV+FwSzat5v+B3Qa1pr4DqRLCWQlsE=; b= L2422ZOPlYW+shWKTjpQzM1e+OoiywS+KJUd5loo9cCngJFR6Q+T5Y8svHXG+fLJ tAnEeXc5MisBrEyCfD4pqY7GaXywmIgugbdZzbOTRcPFMrOlJO7+WPQ/5nYASxxn KR30S8WD/dVQZB38BMTO+ohB1JCQfC5M3g4EZLTTLtde9A46pNnraVpwx9APadDx oNIAL17Ga0QN6AVxWG5LvPyjAJ07vpxZI0jxefIcBXYmxKppIg5p23pgM+2QKCr5 ppqX0miQPZkwKUK0F7jtrTCZMeHksYafj2lQGdEcjn5okyILT4U7KLOIcmYVjVkK XcXwe7GVVyeYufKVqfdVNw== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:content-type:date:date:feedback-id:feedback-id :from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm3; t=1755958986; x= 1756045386; bh=uodYYLMRFoPljHV+FwSzat5v+B3Qa1pr4DqRLCWQlsE=; b=V yMPYVtI9fswKhmTkZ6JeyMv4TkTD4ZxptcqvxfMqCCUI+te7ond6eBbCu2LiTkJe mF9MvSPLCvpjP/MLE9tX+Xy5eOqgD977fqR55sU8ps2wLnjFA9p77PBF7yaBnrkL bzReqv08R2UYSoDFRxiW3n5NfXLCInqkcLGB0qM+SOMP03/gn/G5qUM0+C74IFLo I9NVqSrl+5ZgeiMyMgqbJtN5VK8ktTFzQNSF/cDra9BV2/fsYsKyqXW8lVpgBp8q o9+aLacLPVYBtVbUYhx5c3lA+9xWVEbExWOSa23sl3YBTo3JjKjGWsXEpyQzOIWq NtcWynBzqUz4qmaQ8rTpw== X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeeffedrtdefgdduieeikeejucetufdoteggodetrf dotffvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfurfetoffkrfgpnffqhgenuceu rghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmnecujf gurhepofggfffhvfevkfgjfhfutgfgsehtqhertdertdejnecuhfhrohhmpemllhhvrghr ohcujfgvrhhrvghrrgcuoegrlhhvhhgvrhhrvgeskhhurhhilhgvmhhurdguvgeqnecugg ftrfgrthhtvghrnhepveeggeeugefhtefhgeetvdehkeelleehvdfhtdeuueejvdejjeev keetveekuedvnecuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrh homheprghlvhhhvghrrhgvsehkuhhrihhlvghmuhdruggvpdhnsggprhgtphhtthhopeej pdhmohguvgepshhmthhpohhuthdprhgtphhtthhopegrhhestgihsggvrhhtvggtrdgrth dprhgtphhtthhopegvuhhlvghrsegvuhhlvghrthhordgtohhmpdhrtghpthhtohepmhgr shgrohdrfhhujhhiihesghhmrghilhdrtghomhdprhgtphhtthhopehmihhhrghilhhnih hkrghlrgihvghusehgmhgrihhlrdgtohhmpdhrtghpthhtohepmhgsrghntghksehgmhig rdhnvghtpdhrtghpthhtohepphhgshhqlhdqhhgrtghkvghrsheslhhishhtshdrphhosh htghhrvghsqhhlrdhorhhgpdhrtghpthhtoheprhhosgesgiiiihhllhgrrdhnvght X-ME-Proxy: Feedback-ID: ie3de48e3:Fastmail Received: by mailuser.phl.internal (Postfix, from userid 501) id D06C3C40071; Sat, 23 Aug 2025 10:23:05 -0400 (EDT) X-Mailer: MessagingEngine.com Webmail Interface MIME-Version: 1.0 X-ThreadId: ANbh4HzjMP1N Date: Sat, 23 Aug 2025 16:22:11 +0200 From: =?UTF-8?Q?=C3=81lvaro_Herrera?= To: "Michael Banck" , "Euler Taveira" Cc: "Robert Treat" , pgsql-hackers , "Antonin Houska" , "Fujii Masao" , "Mihail Nikalayeu" Message-Id: <1764804a-2bc1-46e9-9008-82ea39cb8c81@app.fastmail.com> In-Reply-To: <68a9660d.df0a0220.22e722.840c@mx.google.com> References: <202508220940.u6qkixbhu7xs@alvherre.pgsql> <68a9660d.df0a0220.22e722.840c@mx.google.com> Subject: Re: Adding REPACK [concurrently] Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 2025-08-23, Michael Banck wrote: > On Fri, Aug 22, 2025 at 05:32:34PM -0300, Euler Taveira wrote: >> I don't think we need to keep vacuumdb. Packagers can keep a symlink = (vacuumdb) >> to pg_repackdb. We can add a similar warning message saying they shou= ld use >> pg_repackdb if the symlink is used. > > Unless pg_repack has the same (or a superset of) CLI and behaviour as > vacuumdb (I haven't checked, but doubt it?), I think replacing vacuumdb > with a symlink to pg_repack will lead to much more breakage in existing > scripts/automation than clusterdb, which I guess is used orders of > magnitude less frequently than vacumdb. Yeah, I completely disagree with the idea of getting rid of vacuumdb. We= can, maybe, in a distant future, get rid of the --full option to vacuum= db. But the rest of the vacuumdb behavior must stay, I think, because R= EPACK is not VACUUM =E2=80=94 it is only VACUUM FULL. And we want to mak= e that distinction very clear. We can also, in a few years, get rid of clusterdb. But I don't think we= need to deprecate it just yet. --=20 =C3=81lvaro Herrera