A true global database doesn’t battle against the constraints of its architecture. Amazon Aurora claims to be global. But is it? bit.ly/33i2Y80
#globalavailability #globalperformance #globalconsistency
Conversation
Replying to
Interesting post:
* maybe call this tpc-c like unless tpc requirements are to be met
* what about linkbench?
* some tpc-c transactions need more than read committed, maybe tpc-c for PG should use SSI
* serializable in MySQL will not perform well (too many read locks)
1
1
Also: 1) Postgres 12 has indexes that are 40% smaller with TPC-C, and 2) Wonder if "stock" transaction had bad query plan on Aurora Postgres -- I have seen this happen on Postgres (hash join instead of nestloop join). Need full report, with per-xact breakdown.