Re: Need help in database design

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Divyansh Gupta JNsThMAudy <ag1567827(at)gmail(dot)com>, Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Need help in database design
Date: 2024-12-23 18:08:25
Message-ID: 1823b892-facf-4515-a44d-f9a0aa9025da@aklaver.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
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(dot)klaver(at)aklaver(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ron Johnson 2024-12-23 18:09:38 Re: Need help in database design
Previous Message Divyansh Gupta JNsThMAudy 2024-12-23 17:49:25 Re: Need help in database design