logoalt Hacker News

spongeboiyesterday at 4:45 PM2 repliesview on HN

Cross shard transactions are supported, but we don't have support for atomic 2pc cross shard transactions, its WIP


Replies

levkkyesterday at 11:25 PM

Curious to compare your implementation to ours [1] some day (if you guys open source it).

[1]: https://docs.pgdog.dev/features/sharding/2pc/

ragallyesterday at 7:57 PM

Are 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.