5 ms·
I see no mention of foreign keys, or any other constraints, across shards. If, as I suspect, they're not implemented, it would still be useful but at the level
by ragall 6d ago
I see no mention of foreign keys, or any other constraints, across shards. If, as I suspect, they're not implemented, it would still be useful but at the level of Spanner 10 years ago.
- aabhay 6d agoCross shard transactions are “coming soon”. So, this is just like having multiple postgres clusters.
- spongeboi 6d agoCross shard transactions are supported, but we don't have support for atomic 2pc cross shard transactions, its WIP
- ragall 6d agoAre you one of the developers ? If so, you need to add a specific page explaining in detail the guarantees that this gives. For example: point 08 says "Assign different tables or workloads to different shard groups" and point 02 says "Split hot shards as workloads grow". How do those interact ? Can a single table be split across multiple shards ? If so don't you need 2pc to enforce primary key constraints ? The intro pages just read as AI slop.
- levkk 6d agoCurious to compare your implementation to ours [1] some day (if you guys open source it). [1]: https://docs.pgdog.dev/features/sharding/2pc/ https://docs.pgdog.dev/features/sharding/2pc/