PostgreSQL has the JSONB data type which is essentially the same as the BSON type except slightly better optimized for reading partial documents. And PostgreSQL also provides good indexing support for them, and did so before MongoDB.
have you tried using the postgres json data type? it's a joke.
Can you list some reasons?
Not really sure about the `JSON` type, but the `JSONB` type is excellent.
that’s a throwaway opinion, worth the time you spent writing it
Postgres can also be made to shard any table to multiple hosts via the PARTITION BY RANGE/PARTITION OF feature, combined with the FOREIGN DATA WRAPPER (FDW) core extension.