2 ms·
Cross shard transactions are “coming soon”. So, this is just like having multiple postgres clusters.
by aabhay 2mo ago
Cross shard transactions are “coming soon”. So, this is just like having multiple postgres clusters.
- spongeboi 2mo agoCross shard transactions are supported, but we don't have support for atomic 2pc cross shard transactions, its WIP
- ragall 2mo 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 2mo 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/