Horton
Menu

Re: Need help in database design

Adrian Klaver <adrian.klaver@aklaver.com>

View thread
From: Adrian Klaver <adrian.klaver@aklaver.com>
To: Divyansh Gupta JNsThMAudy <ag1567827@gmail.com>, Ron Johnson <ronljohnsonjr@gmail.com>
Cc: pgsql-general <pgsql-general@postgresql.org>
Date: 2024-12-23T18:08:25Z
Lists: 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