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.89) (envelope-from ) id 1iFKAu-0001VI-Ey for pgsql-hackers@arkaria.postgresql.org; Tue, 01 Oct 2019 15:34:52 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iFKAt-0007Ma-4q for pgsql-hackers@arkaria.postgresql.org; Tue, 01 Oct 2019 15:34:51 +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 1iFKAs-0007MP-SM for pgsql-hackers@lists.postgresql.org; Tue, 01 Oct 2019 15:34:50 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iFKAq-0007Y2-QK for pgsql-hackers@postgresql.org; Tue, 01 Oct 2019 15:34:50 +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 x91FYaco002094; Tue, 1 Oct 2019 11:34:36 -0400 From: Tom Lane To: Tomas Vondra cc: Andrey Borodin , Alvaro Herrera , Binguo Bao , Paul Ramsey , Pgsql Hackers Subject: Re: Optimize partial TOAST decompression In-reply-to: <20191001145758.rofbwvguwxwpdxyb@development> References: <20190925203834.GA25060@alvherre.pgsql> <20190926230036.ubxzgkqsphbzmbdl@development> <20190930155607.5tnyzksijgm4imbg@development> <20190930172951.gdedvexnf4d2wv5e@development> <123EF56B-F8EC-4868-B49B-095795095E7A@yandex-team.ru> <20191001100805.wnnuj73kuzfwzs56@development> <20191001123420.uwzxtqr7qvleyxef@development> <20191001131803.j6uin7nho7t6vxzy@development> <4411.1569939037@sss.pgh.pa.us> <20191001145758.rofbwvguwxwpdxyb@development> Comments: In-reply-to Tomas Vondra message dated "Tue, 01 Oct 2019 16:57:58 +0200" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <2092.1569944075.1@sss.pgh.pa.us> Date: Tue, 01 Oct 2019 11:34:35 -0400 Message-ID: <2093.1569944075@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Tomas Vondra writes: > On Tue, Oct 01, 2019 at 10:10:37AM -0400, Tom Lane wrote: >> Maybe it accidentally seems to work on little-endian, thanks to the >> different definitions of varlena headers? > Maybe. Let's see if just using VARSIZE_ANY does the trick. If not, I'll > investigate further. FWIW, prairiedog got past that test, so whatever it is seems specific to big-endian 64-bit. Odd. regards, tom lane