Re: Need help in database design - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Need help in database design
Date
Msg-id 1823b892-facf-4515-a44d-f9a0aa9025da@aklaver.com
Whole thread Raw
In response to Re: Need help in database design  (Divyansh Gupta JNsThMAudy <ag1567827@gmail.com>)
List pgsql-general
On 12/23/24 09:49, Divyansh Gupta JNsThMAudy wrote:
> I have one confusion with this design if I opt to create 50 columns I 
> need to create 50 index which will work with userid index in Bitmap on 
> the other hand if I create a JSONB column I need to create a single index ?
> 

There still is the part where you plan to partition this data on some as 
not yet fully specified hash.


-- 
Adrian Klaver
adrian.klaver@aklaver.com




pgsql-general by date:

Previous
From: Divyansh Gupta JNsThMAudy
Date:
Subject: Re: Need help in database design
Next
From: Ron Johnson
Date:
Subject: Re: Need help in database design