3 ms·
I love JSONB but I don't expect it to perform well for unbounded things suddenly I have to store all items in a single DB row and read the whole thing to acces
by awinter-py 7y ago
I love JSONB but I don't expect it to perform well for unbounded things
suddenly I have to store all items in a single DB row and read the whole thing to access any of them, giving me a new source of IO inefficiency
what if the target table is keyed by date and I'm selecting a small subset? JSONB will still force the DB to interact with the entire JSONB blob.
- acjohnson55 7y agoIn Postgres, JSONB can be indexed in some pretty useful ways. But generally speaking, at some point, sometimes you have to do the less ergonomic thing in the name of performance. I'm just of a mind to postpone that until it's worth the tradeoff. Often, you can architect in such a way that such a change won't cascade through the rest of your system.
- combatentropy 7y agoI use PostgreSQL and JSONB a lot, but JSONB is not the type of any column in any of my tables, only in views and functions.