Re:Towards Multiverse Databases
by acjohnson55 on Monday June 17, 2019 @08:11PM
(#20208597)
In 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.
Re:Towards Multiverse Databases
by combatentropy on Tuesday June 18, 2019 @01:38AM
(#20210063)
I 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.
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.