MIME-Version: 1.0
From: Divyansh Gupta JNsThMAudy <ag1567827@gmail.com>
Date: Mon, 23 Dec 2024 21:23:44 +0530
Message-ID: <CAHesJ5LES3aTDf=xp7NOwrADQ_HWC-Spsv7yLu9ZY+zxzZO53A@mail.gmail.com>
Subject: Need help in database design
To: pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000fe03ca0629f2004d"
Archived-At: <https://www.postgresql.org/message-id/CAHesJ5LES3aTDf%3Dxp7NOwrADQ_HWC-Spsv7yLu9ZY%2BzxzZO53A%40mail.gmail.com>
Precedence: bulk

--000000000000fe03ca0629f2004d
Content-Type: text/plain; charset="UTF-8"

Hii Community,

I need to provide a support for some functionality for my application for
that I need to store 50 key value pair set, so I am in a dilemma, weather I
create 50 new columns of int2 data type each column will contain value of a
specific key or should I go with JSONB data type with 50 key value pair,
the table on which I am going to do that all contains 1 Billion rows of
data and have 84 hash partitions, I have gone through multiple articles
some of them mentioned it's a good approach to create 50 new columns and
some states that creating one JSONB would be best that's why I need your
help to move forward, also I am ready to make H-Store instead of JSONB if
it provides better performance.
Please help me to comes out from that dilemma.

Regards,
Divyansh Gupta,
Database Administrator

--000000000000fe03ca0629f2004d
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"auto">Hii Community,<div dir=3D"auto"><br></div><div dir=3D"aut=
o">I need to provide a support for some functionality for my application fo=
r that I need to store 50 key value pair set, so I am in a dilemma, weather=
 I create 50 new columns of int2 data type each column will contain value o=
f a specific key or should I go with JSONB data type with 50 key value pair=
, the table on which I am going to do that all contains 1 Billion rows of d=
ata and have 84 hash partitions, I have gone through multiple articles some=
 of them mentioned it&#39;s a good approach to create 50 new columns and so=
me states that creating one JSONB would be best that&#39;s why I need your =
help to move forward, also I am ready to make H-Store instead of JSONB if i=
t provides better performance.</div><div dir=3D"auto">Please help me to com=
es out from that dilemma.</div><div dir=3D"auto"><br></div><div dir=3D"auto=
">Regards,</div><div dir=3D"auto">Divyansh Gupta,</div><div dir=3D"auto">Da=
tabase Administrator</div></div>

--000000000000fe03ca0629f2004d--