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 1ubPMk-000RRX-SS for pgsql-general@arkaria.postgresql.org; Mon, 14 Jul 2025 20:01:34 +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 1ubPMi-00D7SI-W9 for pgsql-general@arkaria.postgresql.org; Mon, 14 Jul 2025 20:01:33 +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 1ubPMi-00D7OV-JI for pgsql-general@lists.postgresql.org; Mon, 14 Jul 2025 20:01:33 +0000 Received: from mail-ot1-x32f.google.com ([2607:f8b0:4864:20::32f]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1ubPMh-007I04-1X for pgsql-general@lists.postgresql.org; Mon, 14 Jul 2025 20:01:32 +0000 Received: by mail-ot1-x32f.google.com with SMTP id 46e09a7af769-73a44512c8aso1266793a34.0 for ; Mon, 14 Jul 2025 13:01:31 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1752523291; x=1753128091; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=F3pXTwFMaTo8t0UEIco4O8jrEMJjvJqMPnVdpvMaUvA=; b=bv94BWrE5nEJkFVqy84HhhEpf3ezpOvwpd0RCP8lwnniFP6aYA7silnZZMlPwDOQBz VFrXOEC15yAqFajwzb+ukBwTue4VEi8EwpMEMJmFhspxEkvoFbec60lyqJCMVDk8lnui q6zMX5VfAFALI9Yunn1ZQtgF4xsQIpBR2MJ4VyvDCWzrCI7zsyhPup2P/vzBSOmAKNGp zXxTkpinqbFVBzhthZBuWbkuQPliIHg7oiiyTyZZhIoeWAZayKA/aeG+VRU8QzcsImZc MuP4voqSV5h1O1Bpi4HVJZx85S3Ycy9fALxkDKiXZy8EMYEO+uqOZkx4z/0iVVUCa4Dk cMEg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1752523291; x=1753128091; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=F3pXTwFMaTo8t0UEIco4O8jrEMJjvJqMPnVdpvMaUvA=; b=ZrcHjsQAcXY6PyyFteauH3e3IrXTU1jZzjsb+hD8L3dEQ06JIQ057PbTyZZg7VLxEP AXXWIvX5yRDMZyuXVA+BqjBlRpo1oojDu0ZMZO3FPiQyU1VJWzntwDDrNc9wL37qSW6t 5A/Rcd5yv5/RA3f4wBZeigpoOri1/7bfroPLh8dKMBGHR2is3kJ582dJF8axZM1IkqQI wr4d8Oq74V+8Nc14peXEuVs46PQviBlM5h21Xump+HG2zPoWLVvjVO4cj0ZMgLdU5qau fF6xIYXZlcF9b+QMA+exKhsomNVJSQu1gONy7Mz1MgU3NwCKLooE8E7CUxTtpksoPAj6 4XWw== X-Forwarded-Encrypted: i=1; AJvYcCXvyEOxfeQ1e0OhAG+9d/jNgqimaOHpRGV3SLPLCaMUki8WIzTxQicSAB2jbi8AcN/5C6wjp4UnHiNHeJHk@lists.postgresql.org X-Gm-Message-State: AOJu0Yy6480EDybiic8mgbwUrx9rApnrhKEg0Tc9FGssEQuJ0/vewsVj AawQureO6P8abluen2YRmc4imqudpVCR7Bmnjj9XYxOElXPBU8EKDihLxCxbDrfJtTYpDfQk4io yFyBdYQEj/W1tnyfBIvRIFKMwO1wfLtgHwoxFQuE= X-Gm-Gg: ASbGncsVmh3G40MTfolVjmuKK5RAW9SRJyYB3CJZPqJCuo+HGh9eXBKbYLQwA73aKAr FsBWTic8BVQZ5frrrbJjqtU0gYevxb4ra+zqguj6oBaj8EtfkuEFMm765idB71lmCeX/Pbc4Y2F I1NL/O7/iAYPMla8BZfcfj7Vm/Zd5tNeAA2yfC0muGzkv/+H0sHQiJZUqwGHAf8QVyayK+rR94x 0QoTVDDnW7v6yWXbjx2DuUMIBYLadxpHJFzI/U= X-Google-Smtp-Source: AGHT+IGhx82zOwClcrnBJRREIY+HE2Xxt78TJEa06pdOqCCbHr1bq8rHGuAXlMxM3NM2io91vRD80iLvFXBsGoTnMTE= X-Received: by 2002:a05:6820:1992:b0:615:7d44:2d1d with SMTP id 006d021491bc7-6157d443681mr4998783eaf.3.1752523290614; Mon, 14 Jul 2025 13:01:30 -0700 (PDT) MIME-Version: 1.0 References: <8efa554c-ba95-43d5-953c-def0d53dca9e@aklaver.com> In-Reply-To: <8efa554c-ba95-43d5-953c-def0d53dca9e@aklaver.com> From: "David G. Johnston" Date: Mon, 14 Jul 2025 13:00:54 -0700 X-Gm-Features: Ac12FXzTK6mnhsym3f8E-gPJ-7Y386uu7wVb2UGzi1t8IP1z4wf9EfeesfQKjng Message-ID: Subject: Re: Performance of JSON type in postgres To: Adrian Klaver Cc: veem v , pgsql-general Content-Type: multipart/alternative; boundary="000000000000329f2b0639e920c5" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000329f2b0639e920c5 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Mon, Jul 14, 2025 at 12:54=E2=80=AFPM Adrian Klaver wrote: > On 7/14/25 12:51, veem v wrote: > > So I want to > > understand the experts' opinion on this which I believe will be > > crucial during design itself. > > It is spelled out here: > > https://www.postgresql.org/docs/current/datatype-json.html > > I've taken to heart the main takeaway from that page: "In general, most applications should prefer to store JSON data as jsonb, unless there are quite specialized needs, such as legacy assumptions about ordering of object keys." David J. --000000000000329f2b0639e920c5 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Mon, Jul 14, 2025 at 12:54=E2=80=AFPM Adrian Klaver <= ;adrian.klaver@aklaver.com= > wrote:
On 7/14/25 12:51, vee= m v wrote:
>=C2=A0So I want to
> understand the experts' opinion on this which=C2=A0I believe=C2=A0= will=C2=A0 be
> crucial=C2=A0during design itself.

It is spelled out here:

https://www.postgresql.org/docs/current/d= atatype-json.html


I've taken = to heart the main takeaway from that page:

"In ge= neral, most applications should prefer to store JSON data as jsonb, unless = there are quite specialized needs, such as legacy assumptions about orderin= g of object keys."

David J.

--000000000000329f2b0639e920c5--