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 1oAsGC-0008CF-8c for pgsql-admin@arkaria.postgresql.org; Mon, 11 Jul 2022 12:11: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 1oAsGA-0001hs-NX for pgsql-admin@arkaria.postgresql.org; Mon, 11 Jul 2022 12:11: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 1oAsGA-0001hi-Cn for pgsql-admin@lists.postgresql.org; Mon, 11 Jul 2022 12:11:30 +0000 Received: from mout.gmx.net ([212.227.17.21]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oAsG7-0006cX-Sc for pgsql-admin@lists.postgresql.org; Mon, 11 Jul 2022 12:11:29 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=gmx.net; s=badeba3b8450; t=1657541485; bh=kYTkNZvy7f05SyMdLFJQb+it/rHxQZtCAmf6yA+npwU=; h=X-UI-Sender-Class:Subject:To:References:From:Date:In-Reply-To; b=clXGosUEjb62XthlKwkNgxuOv2rWf6ooJrKSP1k9xV0ZWuH1lmjmpbj2xh+K23i6l 3ZgNEoCONT2LRMHsJC3mVlrhSjMnqDAmeucXnBBMqzOJZGHNChlZWL55TWS1kR0L0y Qt1hKI2xsWTmFMSkvzkCxsgn3qG89wekoCEeh+P8= X-UI-Sender-Class: 01bb95c1-4bf8-414a-932a-4f6e2808ef9c Received: from [10.1.32.106] ([185.40.248.10]) by mail.gmx.net (mrgmx105 [212.227.17.168]) with ESMTPSA (Nemesis) id 1MZTqg-1o60ol1C5O-00WTkw for ; Mon, 11 Jul 2022 14:11:25 +0200 Subject: Re: Storing large large JSON objects in JSONB To: pgsql-admin@lists.postgresql.org References: From: Thomas Kellerer Message-ID: <16681dbd-639c-0d38-d3ee-28c808c05a4d@gmx.net> Date: Mon, 11 Jul 2022 14:11:24 +0200 User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.23) Gecko/20090812 Thunderbird/2.0.0.23 Mnenhy/0.7.6.666 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8 Content-Language: de-DE Content-Transfer-Encoding: quoted-printable X-Provags-ID: V03:K1:0mRBSWz1gQf3Uuw3/IW3JvvK77nUEzqkFt7obR8XD6UXXLPLlED PNch6RkA8UddpD36RBUUQPKyKAVa7B1s3WQ97YLpgkZU6+9udfIhhT6fap/04Xhz4aHGAYa zzuhhP/T4ZhR0WegdeOiVw7cgZ52ys8hVbMnP1oRpa4FnmWmh5kc6ZPwaERNlm5/rLOm3tZ 6DBCgHW1Beg9cYL9qi3iA== X-Spam-Flag: NO X-UI-Out-Filterresults: notjunk:1;V03:K0:UTelqXDx3ec=:5X5ZM3sJLY464ONvX+lGNY WrmSiAd/juxhqMB5iUb+Pja2X9u1chB42AfCRkeAQOneQNzIUwybnXf+IpbhsUcrlapVovy/J ZlMLiOfueoms5LHhyLT1MZ0upQiNIyrFV6uI2rLX3YKseovLh30AiqY3Est7f60k+g80LEnhv CAReI40jjQD5LOVDW2xYcc9qR67yVaxZi7pn4tchn0p0xlA1wQ6VqFp8uzpySFf2j8b4COlq4 YNpS18EGk8AdgDaQcnMgyJNXoW3vISW7WDS+uOyeyAXQoft92Z1RC7LLZEku82usn9a8p8ypM 4C8DSX16Q2oA6hOoisya3e2fc2LKSQqZUsM3K6pgNn+C5gxMrtq4fiHHaOmoR+bJo4nOu1bl1 TbahaS/NZoMSpojIxZSKXcoPSZY8EYmdNbw0xi9Wv/tXphFr0TvdRPOfqGTceCmDyJjmvtK5h pJngq4Utbeh1RmyrBBr5IDDkbyP3pMzhhbddVmncswZxa5+gqi2wxOFHlnvQArox5g+9RumzQ eQz8dYO9oU5ZnqSn7UXHYR4tVkUOWZgVdZxkleyK8Se4N2J+8hB+XM+iidB2mHY1vo/Zyvy28 ZbXPU0okaV9FHJUBO5N2D5NRG/yP2hq+QfuFakpCVfqB2gwpBGmWPw4vuVtkP9FG8H9OwqeKr oD9hwb0fZ20p7vpqG9wm0jGSPmY0FM1t/zRzO810GsnAJEpybYVzg4EKYdZGQfL2zp2i6iYYb QNGV94FBikzraJ/llLs6CaDWed6SUQibRtePi0gxwSg++mUwWFMNpE6oonCPHcWRH1R0fGLOT gXjUhO8Ubynf8YCwp10/GMriA5XbfI5yEyNDpZ/xEzOlW1piab3YybrFnNj3d3cJTM73/2y4t nYEcdUu6dmG2LTBiirIgNun6dWUNa1QwxRUhqvAPVNF6xQaEABU77N/jkOJooK6pr4CownVZS Kyy9cMstTssrWkTL195IiEK+gZFNTze41os2aH35Mr/JqInyCBvw1U8Ge2KNrpzdYvPLbLKK+ FqQgBZWgy07JRt+IpARUOOZ0VLjXqTJUcuaMz1bBDKaexp9LhDGkbABw+yibE2ISr0Tj+jVco CeqcYcLi0IXbbiSV/Lk+hdkQZ0p3BADGYDWBsyhW1GIOqhE3yGFOtarMA== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Wells Oliver schrieb am 09.07.2022 um 21:37: > We have a couple of tables where we like to store very large JSON > objects in a JSONB column. Note, that the upper limit for a single jsonb value is 255MB Not 1GB as it is e.g. the case for text or json.