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.92) (envelope-from ) id 1j7p1G-0000AH-L7 for pgsql-hackers@arkaria.postgresql.org; Fri, 28 Feb 2020 23:26:10 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1j7p1F-0000d2-Eb for pgsql-hackers@arkaria.postgresql.org; Fri, 28 Feb 2020 23:26:09 +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 1j7p1F-0000cv-5l for pgsql-hackers@lists.postgresql.org; Fri, 28 Feb 2020 23:26:09 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1j7p1C-0004CQ-Ua for pgsql-hackers@postgresql.org; Fri, 28 Feb 2020 23:26:08 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.4/8.14.4) with ESMTP id 01SNQ4uL017938; Fri, 28 Feb 2020 18:26:04 -0500 From: Tom Lane To: Justin Pryzby cc: Alvaro Herrera , Amit Langote , pgsql-hackers@postgresql.org Subject: Re: ALTER tbl rewrite loses CLUSTER ON index (consider moving indisclustered to pg_class) In-reply-to: <20200207143935.GP403@telsasoft.com> References: <20200206144426.GH403@telsasoft.com> <20200206172447.GA28041@alvherre.pgsql> <20200207143935.GP403@telsasoft.com> Comments: In-reply-to Justin Pryzby message dated "Fri, 07 Feb 2020 08:39:35 -0600" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <17936.1582932364.1@sss.pgh.pa.us> Content-Transfer-Encoding: quoted-printable Date: Fri, 28 Feb 2020 18:26:04 -0500 Message-ID: <17937.1582932364@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Justin Pryzby writes: > I think the attached is 80% complete (I didn't touch pg_dump). > One objection to this change would be that all relations (including indi= ces) > end up with relclustered fields, and pg_index already has a number of bo= ols, so > it's not like this one bool is wasting a byte. > I think relisclustered was a's clever way of avoiding that overhead (c0a= d5953). > So I would be -0.5 on moving it to pg_class.. > But I think 0001 and 0002 are worthy. Maybe the test in 0002 should liv= e > somewhere else. 0001 has been superseded by events (faade5d4c), so the cfbot is choking on that one's failure to apply, and not testing any further. Please repost without 0001 so that we can get this testing again. regards, tom lane