3 ms·
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 o
by wdb 6y ago
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.
- mateuszf 6y agoTry with Aurora Postgres Global Database, it's on AWS, but should be accessible from other clouds.
- jatone 6y agogenerally 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.