If PostgreSQL has great support for JSONB, why do we need columns anymore? Why not just create a table with a JSONB blob and get rid of all columns like the schema below:Īt the end of the day, columns are still the most efficient technique to work with your data. For the purposes of this blog, when we refer to JSON support in PostgreSQL, we will refer to JSONB going forward. JSONB - however, if you do any further processing, JSONB will be faster.įor example, if you're just ingesting JSON logs and not querying them in any way, then JSON might be a better option for you.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |