public inbox for [email protected]  

help / color / mirror / Atom feed

From: Divyansh Gupta JNsThMAudy <[email protected]>
To: [email protected]
Subject: Need help in database design
Date: Mon, 23 Dec 2024 21:23:44 +0530
Message-ID: <CAHesJ5LES3aTDf=xp7NOwrADQ_HWC-Spsv7yLu9ZY+zxzZO53A@mail.gmail.com> (raw)

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

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Need help in database design
  In-Reply-To: <CAHesJ5LES3aTDf=xp7NOwrADQ_HWC-Spsv7yLu9ZY+zxzZO53A@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox