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

From David G. Johnston
Subject Re: Need help in database design
Date
Msg-id CAKFQuwYdpzwcbSdQ8TvZ-nVjPeHVVz+5=bWofCbUK+p_o=axrQ@mail.gmail.com
Whole thread Raw
In response to Re: Need help in database design  (Divyansh Gupta JNsThMAudy <ag1567827@gmail.com>)
Responses Re: Need help in database design
List pgsql-general


On Mon, Dec 23, 2024, 10:01 Divyansh Gupta JNsThMAudy <ag1567827@gmail.com> wrote:


So here my question is considering one JSONB column is perfect or considering 50 columns will be more optimised.

The relational database engine is designed around the column-based approach.  Especially if the columns are generally unchanging, combined with using fixed-width data types.

David J.

pgsql-general by date:

Previous
From: Divyansh Gupta JNsThMAudy
Date:
Subject: Re: Need help in database design
Next
From: Adrian Klaver
Date:
Subject: Re: Need help in database design