Re:Our Journey to PostgreSQL 12
by rossmohax on Wednesday January 27, 2021 @07:10AM
(#25927247)
It doesn't matter how you arrange data, the moment you need to commit to 2 shards transactionally you are either having consistency trouble or performance trouble.
Both your schemas require writes to at least 2 shards transactionally.
Both your schemas require writes to at least 2 shards transactionally.