It's worth reading the Fly piece on designing for geographically replicated PostgreSQL, it's absolutely brilliant: https://fly.io/docs/getting-started/multi-region-databases/