News for hackers. Stuff that matters.
Re:Towards Multiverse Databases by awinter-py on Monday June 17, 2019 @05:30PM (#20207575)
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.

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.