PgDog is funded and coming to a database near you

Re:PgDog is funded and coming to a database near you by levkk on Wednesday June 10, 2026 @09:25PM (#48485152)

fwiw, we support cross-shard transactions. They are not magic though, just good old 2pc and a bit of coordination.

[ Parent | on HN ]

Re:PgDog is funded and coming to a database near you by inigyou on Thursday June 11, 2026 @05:22AM (#48488107)

2pc is only safe if every part of the system has guaranteed uptime, which it never does. Assume that cross-shard transactions only work in the happy case and may result in inconsistent data otherwise.

They also reduce the benefit of sharding, possibly down to worse performance than a non-sharded DB.

[ Parent | on HN ]

Re:PgDog is funded and coming to a database near you by levkk on Thursday June 11, 2026 @09:49AM (#48490317)

For sure. They should be used for "metadata"-style tables only. High throuput writes should be direct-to-shard.

[ Parent | on HN ]