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@xxxxxxxxxxx