Need help in database design

Поиск
Список
Период
Сортировка
От Divyansh Gupta JNsThMAudy
Тема Need help in database design
Дата
Msg-id CAHesJ5LES3aTDf=xp7NOwrADQ_HWC-Spsv7yLu9ZY+zxzZO53A@mail.gmail.com
обсуждение исходный текст
Ответы Re: Need help in database design
Список 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

В списке pgsql-general по дате отправления: