undefined | Better HN

0 pointswdb5y ago0 comments

I really enjoy using PostgreSQL only I just don't know how to make it scale easily. Running it on large VM in the cloud works fine until you have lots of data or need it easily accessible. How can you have the data in three different regions (e.g. Europe, US, Asia) when you using something like Google Cloud? Seems to be a hard problem to crack.

0 comments

jatone5y ago

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.

mateuszf5y ago

Try with Aurora Postgres Global Database, it's on AWS, but should be accessible from other clouds.

j / k navigate · click thread line to collapse