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 1lm1hY-00083a-AJ for pgsql-hackers@arkaria.postgresql.org; Wed, 26 May 2021 22:08:32 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lm1hW-0005ll-Oo for pgsql-hackers@arkaria.postgresql.org; Wed, 26 May 2021 22:08:30 +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 1lm1hW-0005jl-4K for pgsql-hackers@lists.postgresql.org; Wed, 26 May 2021 22:08:30 +0000 Received: from wout3-smtp.messagingengine.com ([64.147.123.19]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lm1hT-0003VS-9H for pgsql-hackers@postgresql.org; Wed, 26 May 2021 22:08:28 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.west.internal (Postfix) with ESMTP id 4D4C3141F; Wed, 26 May 2021 18:08:25 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute4.internal (MEProxy); Wed, 26 May 2021 18:08:25 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-transfer-encoding:content-type :date:from:in-reply-to:message-id:mime-version:subject:to :x-me-proxy:x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s= fm2; bh=cmv2YIMhUzhCsrqXKw72rzfP5gHGWM9jyqlqkrlWh2s=; b=BhCUOYqm MEr50IAzLez6CoN3cYnkyRkjCfdn9d0illlsXiQXZf7CGz0wvKRmmtYw8tYyHMv7 2ml2jglwxKXNldFVvuv40PoIXt0GNZT86G6z4JTB36belNS7fAykaZGrXUcnk9I0 G8BntePATKNpRS7cpNz8mxHFy2FJe2AztwoWy2rSz0DykWChaw9fI4HcCtXJS1Wu oD5FpbjsX6sNExYiwiNuJ2Btegfk88QoMXtVPkR5LVmSXdrU229HBVWvJfU8nOt/ EFfJY8DTmUIjqhFud4IwPHRqtWkWyJB8+oSbHD+Q/rQd2j86FsdNDxgMHbpUUBFi /JOWrmKy6kFI1w== X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeduledrvdekgedgtdegucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne cujfgurhepfffhvffukfggtggugfgjsehtkeertddttddunecuhfhrohhmpeetlhhvrghr ohcujfgvrhhrvghrrgcuoegrlhhvhhgvrhhrvgesrghlvhhhrdhnohdqihhprdhorhhgqe enucggtffrrghtthgvrhhnpeeggeevveffveejffdutefhvddtgeeghffhgfeuhfefjeei gfevhfefleevtdduteenucfkphepudeltddrleehrdduledrleehnecuvehluhhsthgvrh fuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomheprghlvhhhvghrrhgvsegrlhhv hhdrnhhoqdhiphdrohhrgh X-ME-Proxy: Received: from perhan.alvh.no-ip.org (unknown [190.95.19.95]) by mail.messagingengine.com (Postfix) with ESMTPA; Wed, 26 May 2021 18:08:23 -0400 (EDT) Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000) id 31C0B2A0A8B; Wed, 26 May 2021 18:08:20 -0400 (-04) Date: Wed, 26 May 2021 18:08:20 -0400 From: Alvaro Herrera To: Tom Lane Cc: Robert Haas , Michael Paquier , Justin Pryzby , Andres Freund , pgsql-hackers@postgresql.org, Dilip Kumar Subject: Re: Move pg_attribute.attcompression to earlier in struct for reduced size? Message-ID: <202105262208.iwm6dxqv2puy@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <1618250.1622059906@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 2021-May-26, Tom Lane wrote: > I wrote: > > I think this is about ready to commit now (though I didn't yet nuke > > GetDefaultToastCompression). > > Here's a bundled-up final version, in case anybody would prefer > to review it that way. Looks good to me. I tested the behavior with partitioned tables and it seems OK. It would be good to have a test case in src/bin/pg_dump/t/002_pg_dump.pl for the case ... and I find it odd that we don't seem to have anything for the "CREATE TABLE foo (LIKE sometab INCLUDING stuff)" form of the command ... but neither of those seem the fault of this patch, and they both work as [I think] is intended. -- Álvaro Herrera Valdivia, Chile "Estoy de acuerdo contigo en que la verdad absoluta no existe... El problema es que la mentira sí existe y tu estás mintiendo" (G. Lama)