generally speaking the only reason that would be difficult would be due to legal constraints on the data locality.

if it was just performance than read only replica's in each region would solve most of the issues.

for the legal case generally I just end up with a separate postgresql DB in each region and during login the region is determined by user/company.

usually ends up being like 1k LOCs total.