3 ms·
You could pull those out and index them using generated columns, though. That can make things a lot easier on the application side, where the code just needs t
by conradev 5y ago
You could pull those out and index them using generated columns, though.
That can make things a lot easier on the application side, where the code just needs to insert the JSON blob
- jrochkind1 5y agoYou don't even have to "pull those out and index them using generated columns" to index with postgres jsonb, although it's a bit more confusing to figure out the proper index and make sure your queries hit it, jsonb data is indexable on it's own.