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