2 ms·
Citus is an older one that does something like this, right? But it's an extension, not a proxy.
by frollogaston 5mo ago
Citus is an older one that does something like this, right? But it's an extension, not a proxy.
- parthdesai 5mo agoI could be wrong, but with Citus, for most use cases, you can only have one co-ordinator node which fans out requests. So theoretically, you still can run into bottle necks at some point if 1 coordinator node is not enough. With proxies like pgdog, multigres, and eventually Neki, these can scale out horizontally, so you get true unlimited scale.
- frollogaston 5mo agoDoesn't PgDog only have one proxy, or can you have multiple? I imagine they'd need to coordinate on sharding rules somehow.
- levkk 5mo agoYou can have multiple. All sharding is config-based, so no real-time synchronization is required.