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 1rEFF6-004jP9-4c for pgsql-general@arkaria.postgresql.org; Fri, 15 Dec 2023 20:57:08 +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 1rEFF4-005Sq3-Ar for pgsql-general@arkaria.postgresql.org; Fri, 15 Dec 2023 20:57:06 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rEFF2-005Spu-Jx for pgsql-general@lists.postgresql.org; Fri, 15 Dec 2023 20:57:05 +0000 Received: from out2-smtp.messagingengine.com ([66.111.4.26]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rEFEy-00AZs1-4y for pgsql-general@lists.postgresql.org; Fri, 15 Dec 2023 20:57:02 +0000 Received: from compute2.internal (compute2.nyi.internal [10.202.2.46]) by mailout.nyi.internal (Postfix) with ESMTP id D35385C02A9; Fri, 15 Dec 2023 15:56:57 -0500 (EST) Received: from mailfrontend2 ([10.202.2.163]) by compute2.internal (MEProxy); Fri, 15 Dec 2023 15:56:57 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h= cc:cc:content-transfer-encoding:content-type:content-type:date :date:from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to; s=fm1; t=1702673817; x=1702760217; bh=0j/++usdkeMH9urJYpo7ZplY9M4KLugRIY4TwLjVEiY=; b= fSkKbNcltaXv4fhkV0+DLq8DVjRFFLwtblhh0BsKKrFh1DtTo131LWLcTELfzAmf ceKyXKvqRivijeYLI3i6Mv11EGkuMo9iqnCePf3XVlbomXaCmRyuKSFysYvlSHok fbceXZIF/ivjVNBrKy6JuJjearglrzPx1MNGJuuulCxsNUyimC7tUMZKLKM85tDu APuyzJIERH7sBZlMRHnRlK0OKUoMeC9vx94Ofy5vwtPs8TTQoiiekTWIvMNOKbSQ cYfDz1bXE+PQH9bYsNAjPA/O1rnJCb+VpvTUM+iYHLMazw38ufW808p6T6nZpF/e 6NUZy/SMgrxG/dfLSu7fcw== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:content-type:date:date:feedback-id:feedback-id :from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to:x-me-proxy:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm2; t=1702673817; x= 1702760217; bh=0j/++usdkeMH9urJYpo7ZplY9M4KLugRIY4TwLjVEiY=; b=Q RQBoiSLzQYmg9fIVS0bX3AdIqy505oqgVYgvBuaMog/Bg3Wexr+n+VldurXWIRuF dZxdxJVosrHJTI4M7guujWtI30J7qDQGXaz/O9A3Kzyz45AIVNnC7C8sjbPuLgyh cjgVHNPvvKsLA/JTbQrSZLcduTbvFbz1g1RgwdgOuW0mEgS45S4f0es0PvAmPGbA 2E3jmYGsZjgcLGPtc2WlHXVLx6GolPnSxlCIyTTpD7Z46xHVouV7b/UR6q0SJq3v cU/1raaeCoweS6kdNyNkaKbVqjrkmNZCYqaaIB92KLQBo19AC45jKTKANuBzKPJH 15lzYAeIKza5iuE3L7eWg== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvkedrvddtvddgudegvdcutefuodetggdotefrod ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfgh necuuegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmd enucfjughrpefkffggfgfuvfevfhfhjggtgfesthekredttddvjeenucfhrhhomheptegu rhhirghnucfmlhgrvhgvrhcuoegrughrihgrnhdrkhhlrghvvghrsegrkhhlrghvvghrrd gtohhmqeenucggtffrrghtthgvrhhnpeefgeefieeutdfggfetgefgheekjeehteeileei gfetieekjedvieeviefgheevtdenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmh epmhgrihhlfhhrohhmpegrughrihgrnhdrkhhlrghvvghrsegrkhhlrghvvghrrdgtohhm X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Fri, 15 Dec 2023 15:56:56 -0500 (EST) Message-ID: <05dd34df-0fc3-4727-aedb-6232d1ccdd61@aklaver.com> Date: Fri, 15 Dec 2023 12:56:55 -0800 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Increased storage size of jsonb in pg15 To: Sean Flaherty , "David G. Johnston" Cc: pgsql-general@lists.postgresql.org References: <87680387-ed25-41ff-b6de-37e357398df9@aklaver.com> Content-Language: en-US From: Adrian Klaver In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 12/15/23 12:43, Sean Flaherty wrote: > We did a little more digging on our side, which I apologize for not > doing beforehand. > > We wrote a script to create a simple table with a jsonb column, inserted > some json data into the column and then used *pg_column_size* to test > the size of the jsonb data column. > > We ran the script against local docker versions of postgres 14.8 and > 15.5 and saw that the data in the jsonb column was the same size. > > We then ran the script on AWS RDS Postgres and saw a size difference for > the same json data between versions 14.8 and 15.4 (we also saw the > larger size on RDS postgres 15.5 and 16.1). This points at RDS Postgres being the issue. Since that is behind the AWS curtain, you will need to contact AWS technical support for information on what changed. > > *Version* *size (kb)* *notes * > RDS Postgres-14.8 1587 (the same size we were seeing locally) > RDS Postgres-15.4 2112 > > > Thank you for your prompt responses and assistance. > > If you are curious, I can share the script we used with you. > > > Kind regards, > Sean -- Adrian Klaver adrian.klaver@aklaver.com