3 ms·
If you need to index over data inside JSON, why not pull out the pieces that need to be indexed into normal relational columns? When I've used Postgres JSON fi
by yowlingcat 3y ago
If you need to index over data inside JSON, why not pull out the pieces that need to be indexed into normal relational columns?
When I've used Postgres JSON fields in the past, I've used it for unstructured data that doesn't need to be indexed, as if there's anything that does need to be indexed, then it's important enough to extract out to a field for efficiency.
- bhouston 3y agoYes. We are saying the same thing. Treat json in Postgres as a little blob of unstructured data and do not design things in Postgres as you would in mongodb. Minimize json in Postgres or you will have a bad time.