What are the key considerations for scaling PostgreSQL in a multi-cloud environment?