Re:Unstructured Datatypes in Postgres – Hstore vs. JSON vs. ...
by mynameislegion on Wednesday July 20, 2016 @08:56PM
(#12133781)
Does jsonb work with CitusDB? Like can I have a sharded and indexed cluster of postgres dbs? That'd be really awesome if they work together.
[ Parent
| on HN ]
Re:Unstructured Datatypes in Postgres – Hstore vs. JSON vs. ...
by craigkerstiens on Wednesday July 20, 2016 @09:04PM
(#12133808)
Yep, JSONB works great with Citus. It's a model we've seen a few customers follow and the example towards the end are two common use cases where we see it most commonly used (event streams where data doesn't always exist across all columns, and when schemas may commonly vary a bit but you still need to find a shard key and data model that can be shared across them).