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 n

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.