Horton
Menu

Re: Need help in database design

David G. Johnston <david.g.johnston@gmail.com>

View thread
From: "David G. Johnston" <david.g.johnston@gmail.com>
To: Divyansh Gupta JNsThMAudy <ag1567827@gmail.com>
Cc: Adrian Klaver <adrian.klaver@aklaver.com>, pgsql-general@lists.postgresql.org
Date: 2024-12-23T17:08:09Z
Lists: 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.