Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rJDlY-00CDqJ-P3 for pgsql-general@arkaria.postgresql.org; Fri, 29 Dec 2023 14:23:12 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rJDlU-008zvc-RX for pgsql-general@arkaria.postgresql.org; Fri, 29 Dec 2023 14:23:08 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rJDlU-008zv8-Ga for pgsql-general@lists.postgresql.org; Fri, 29 Dec 2023 14:23:08 +0000 Received: from sss.pgh.pa.us ([68.162.161.243]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rJDlR-00ETvb-QY for pgsql-general@lists.postgresql.org; Fri, 29 Dec 2023 14:23:07 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.15.2/8.15.2) with ESMTP id 3BTEMxo73049375; Fri, 29 Dec 2023 09:22:59 -0500 From: Tom Lane To: Junwang Zhao cc: Adrian Klaver , Sean Flaherty , "David G. Johnston" , pgsql-general@lists.postgresql.org Subject: Re: Increased storage size of jsonb in pg15 In-reply-to: References: <87680387-ed25-41ff-b6de-37e357398df9@aklaver.com> <05dd34df-0fc3-4727-aedb-6232d1ccdd61@aklaver.com> <23b98884-10e6-4a2c-af8d-a0fad18c9f3c@aklaver.com> Comments: In-reply-to Junwang Zhao message dated "Fri, 29 Dec 2023 18:05:37 +0800" MIME-Version: 1.0 Content-Type: text/plain; charset="UTF-8" Content-ID: <3049373.1703859779.1@sss.pgh.pa.us> Content-Transfer-Encoding: quoted-printable Date: Fri, 29 Dec 2023 09:22:59 -0500 Message-ID: <3049374.1703859779@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Junwang Zhao writes: > On Fri, Dec 29, 2023 at 4:47=E2=80=AFAM Adrian Klaver wrote: >> For what purpose? You are seeing differences in compression strategies >> between lz4 and pglz. The 'fix' would be to go back to pglz. > Agreed, lz4 is known for its high compression speed, but lower > compression ratio, this is the trade off one should bear in mind. I don't know if we can make any blanket statements like that, but if we can, shouldn't there be some advice in the manual? AFAICS, right now there's exactly zip about why you should choose one over the other. regards, tom lane