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 1iFIrZ-0007D9-RA for pgsql-hackers@arkaria.postgresql.org; Tue, 01 Oct 2019 14:10:49 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iFIrY-0000DH-Jt for pgsql-hackers@arkaria.postgresql.org; Tue, 01 Oct 2019 14:10:48 +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 1iFIrY-0000D0-AZ for pgsql-hackers@lists.postgresql.org; Tue, 01 Oct 2019 14:10:48 +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 1iFIrW-0006jC-7W for pgsql-hackers@postgresql.org; Tue, 01 Oct 2019 14:10:47 +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 x91EAbqZ004412; Tue, 1 Oct 2019 10:10:37 -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: <20191001131803.j6uin7nho7t6vxzy@development> References: <20190710144725.kaswinyw2bdgb6tz@development> <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> Comments: In-reply-to Tomas Vondra message dated "Tue, 01 Oct 2019 15:18:03 +0200" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <4410.1569939037.1@sss.pgh.pa.us> Date: Tue, 01 Oct 2019 10:10:37 -0400 Message-ID: <4411.1569939037@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Tomas Vondra writes: > Hmmm, this seems to trigger a failure on thorntail, which is a sparc64 > machine (and it seems to pass on all x86 machines, so far). gharial's not happy either, and I bet if you wait a bit longer you'll see the same on other big-endian machines. > I wonder if that's wrong, somehow ... Maybe it should use VARSIZE_ANY, > but then how would it work on any platform and only fail on sparc64? Maybe it accidentally seems to work on little-endian, thanks to the different definitions of varlena headers? regards, tom lane