| From: | Divyansh Gupta JNsThMAudy <ag1567827(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Need help in database design |
| Date: | 2024-12-23 15:53:44 |
| Message-ID: | CAHesJ5LES3aTDf=xp7NOwrADQ_HWC-Spsv7yLu9ZY+zxzZO53A@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2024-12-23 16:26:41 | Re: Using Expanded Objects other than Arrays from plpgsql |
| Previous Message | Ivan Shershnev | 2024-12-23 10:00:00 | Re: Seamless age (xid) replacement |