3 ms·
Citus is offered as a Postgres extension, primarily allowing you to run a cluster of postgres servers together as a single logical database with tables automati
by manigandham 10y ago
Citus is offered as a Postgres extension, primarily allowing you to run a cluster of postgres servers together as a single logical database with tables automatically sharded by a key of your choosing.
Slightly limited but distributed SQL queries can run across all nodes to speed up access or scan lots of data - or you can choose something like a customer_id to shard all the tables the same way so that all data for that customer would be on the same node, allowing for full SQL syntax and features on data of that node (because it would just be a regular postgres server).
For a data-warehouse/fast-realtime scenario, I would also recommend MemSQL although it is proprietary.