Feedback-ID: i76984098:Fastmail
Message-ID: <e6d14a61-d1a0-4163-86a6-155e1dc6294f@aklaver.com>
Date: Mon, 23 Dec 2024 09:07:12 -0800
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Need help in database design
To: Divyansh Gupta JNsThMAudy <ag1567827@gmail.com>
Cc: pgsql-general@lists.postgresql.org
References: <CAHesJ5LES3aTDf=xp7NOwrADQ_HWC-Spsv7yLu9ZY+zxzZO53A@mail.gmail.com>
 <b450927c-49da-46e5-ad74-bf38ceff166b@aklaver.com>
 <CAHesJ5+ASNoSNMiC5Ms0Ts=gw7v2_UeBpUT=phujO4yE_XCbEw@mail.gmail.com>
 <CAHesJ5JbkCBZ2f_AvUr8+KWnGPAsobu4zyfnWm8bEeb7X9oqDQ@mail.gmail.com>
 <06e1f1ee-74b2-43a2-9a63-da20ae455ae2@aklaver.com>
 <CAHesJ5JLzhHiGSBSkJZ7x7rGgHeeByP=wWk1D5GG=x8cJ5YY6Q@mail.gmail.com>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <CAHesJ5JLzhHiGSBSkJZ7x7rGgHeeByP=wWk1D5GG=x8cJ5YY6Q@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Archived-At: <https://www.postgresql.org/message-id/e6d14a61-d1a0-4163-86a6-155e1dc6294f%40aklaver.com>
Precedence: bulk

On 12/23/24 09:01, Divyansh Gupta JNsThMAudy wrote:
> Sure , for example, I have 50 key with name as t1 , t2 ,t3 .......t50
> 
> Now each key could have values from 0 to 3
> 
> So let suppose we have JSONB like that for row r1
> 
> {
> 
> t1: 1
> 
> t2: 2
> 
> t3 : 3
> 
> }
> 
> 
> As if I convert it into columns so r1 will have
> 
> t1 column will contain 1
> 
> t2 column will contain 2
> 
> ...... So on
> 
> 
> So here my question is considering one JSONB column is perfect or 
> considering 50 columns will be more optimised.
> 

1) How are you going to use the key:value pairs in queries?

2) I would recommend creating a sample dataset that you import into 
tables that are built with either the column method or the JSON method 
and test a representative set of queries.

-- 
Adrian Klaver
adrian.klaver@aklaver.com