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 1kjyjQ-00069o-HF for pgsql-hackers@arkaria.postgresql.org; Tue, 01 Dec 2020 06:01:44 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kjyjP-0004rN-GH for pgsql-hackers@arkaria.postgresql.org; Tue, 01 Dec 2020 06:01:43 +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 1kjyjP-0004rF-9G for pgsql-hackers@lists.postgresql.org; Tue, 01 Dec 2020 06:01:43 +0000 Received: from wout2-smtp.messagingengine.com ([64.147.123.25]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kjyjN-0002uX-3j for pgsql-hackers@lists.postgresql.org; Tue, 01 Dec 2020 06:01:42 +0000 Received: from compute7.internal (compute7.nyi.internal [10.202.2.47]) by mailout.west.internal (Postfix) with ESMTP id 28A67D4B; Tue, 1 Dec 2020 01:01:38 -0500 (EST) Received: from mailfrontend2 ([10.202.2.163]) by compute7.internal (MEProxy); Tue, 01 Dec 2020 01:01:38 -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=8zXT1Ssy5qVCHCqHKWl1NZHrhiz iLlx4Fd8qWGO/1N0=; b=XR5QeDQMit7B5ef+8M4u8JbDTS72By8tjOCfar1nLYW VX/Tte7vfW12lVt6y5uc+g2/ujUz8FZG4iF7UJnbRBwImY8rsW2eMxJZkZ7uXYyi /oGGx3D1V+rBINgsZmi+mEJ5ONryqX5jnkT6iPd/3wUm/zSrt2WYj7hkeuxhaOY4 GG1Ec5PeKv2e9mNdHG9rT+Yd8g4pTly2YAIp5LAmmx9YdKXChfxxJGO7Kl6J332D Yy90QJ4SW3CZyPOBaxbE81PmM25rLpBKDiM1ezVuahYCuRKKHXyS8IYCWigdAnOm /XFdLALxPtdzW0nf+BlnfISsOX/uDplczNO1BSgP0bQ== 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=8zXT1S sy5qVCHCqHKWl1NZHrhiziLlx4Fd8qWGO/1N0=; b=m0PgOR272Tga5TcrHPgXHg tiXF/+OIMA0my/Y0beQBS4ry0A+UiCC73PM3pMuxNgP3U2jFuoJo3QK+p/LF1ElT rjXJCU1y+YAdGs4+rGn5NXwhPJrpnAZxlwKB03HI/4gMwt09w32wz1GChTYZbQ16 i7QBqIcFTYB7aZc7DAIbpi2Ck5A1Rc2nfww2o0mnn5BUEKNi9YqbHScMrAtJ22vO iWkesK4kBhaJqmvFGEKaJEgrSQf6w28nfIiL/zdw97FtvwVuXLe0odpnvoqnaZWh oCTsgNi+IHJvqRc8p/VZDPO+tYRU+GsP8rVhukd3kBQMVJw8HYezShMElI3MBgGA == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedujedrudeiuddgkeekucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne gfrhhlucfvnfffucdljedtmdenucfjughrpeffhffvuffkfhggtggujgesghdtreertddt vdenucfhrhhomhepofhitghhrggvlhcurfgrqhhuihgvrhcuoehmihgthhgrvghlsehprg hquhhivghrrdighiiiqeenucggtffrrghtthgvrhhnpedvgeduuefhtdeuleettdevjeeh heeiveeuieegleetgeeljeelieeuieehgeevhfenucfkphepudduuddruddtvddrudektd drudekheenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhm pehmihgthhgrvghlsehprghquhhivghrrdighiii 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 709261080057; Tue, 1 Dec 2020 01:01:36 -0500 (EST) Date: Tue, 1 Dec 2020 15:01:33 +0900 From: Michael Paquier To: Thomas Munro Cc: Pavel Borisov , PostgreSQL Hackers Subject: Re: BUG #16663: DROP INDEX did not free up disk space: idle connection hold file marked as deleted Message-ID: References: <16663-fe97ccf9932fc800@postgresql.org> <160624299337.7563.13562988821961887884.pgcf@coridan.postgresql.org> <160624435783.7564.2550264874132085886.pgcf@coridan.postgresql.org> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="Xe2vFlUvOdh6eqep" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --Xe2vFlUvOdh6eqep Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Tue, Dec 01, 2020 at 04:06:48PM +1300, Thomas Munro wrote: > I felt on balance it was a "bug", since it causes operational > difficulties for people and was clearly not our intended behaviour, > and I announced this intention 6 weeks ago. Oops, sorry for missing this discussion for such a long time :/ > Of course I'll be happy to revert it from the back-branches if > that's the consensus. Any > other opinions? If there are no other opinions, I am also fine to rely on your judgment. -- Michael --Xe2vFlUvOdh6eqep Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAl/F3D0ACgkQnvQgOdby QH1UcQ/+NE6gJdBJ8UYSS2QMMeU6xdfqKCpkKhd0J1fbcq3ZVx1qoc7QsRLI/34j MsYZ7TGqtdRyfjTMwBvSHluX6KuCiv1i7jxR1BPzQN7JEVRz+UHCr4dH4+YF9JvC e0A3s0+8OdyB4Z3vB4+iGTP88wXlQ3yJG93Rq6XeG0BLzf05TFxDe06XS80YQxlA r7lYxzfTHHOQTs2m70STufhjmJBtBVGn/9nqYxQf8LIIeasGTryvd1Ee1J6HVBwY OA2/ro1p7AkO3IhIf/XYp2y/W1nM+mFW9QybcHGw/hIXa6GGVIXCw6uXjnjHiHO4 O0QknOh13WWDXbam//UY44TXCSx9huGYUhx6ah1faysPzUFnOcelrJXLZrjQHKT5 gAtCPHJlXxAEnc35OjluThakmVkAB05AO0zWINTmDLCARlgCH21HCOm0wHAFBC0d RuhWZIF6DwxdO7bbN9NzDxXZ6qm6dMP/fKSRLdupFro7sOMETy5lJ9NLF4aSahDG DfY99T1IDhU/mM7uCNB5kD4NfQB83uqGVEk+F3LZFVO2dihkDtffkFSC0sLg2trl 7QDypyZmU10ap6wddcBIT4VAutHCtjIjX1YfA55gcIPqJmtEqFHMZmSPgrSmnEhP aeUKbeXmK6uBM2EbggJmVG1cZaj30o+5d77+0C/5Aa5bfAfGbBo= =d4GD -----END PGP SIGNATURE----- --Xe2vFlUvOdh6eqep--