jsonb queries in postgres have been very performant for us over +tb data sets. however, we often materialize views of large json blobs, just cause we can.