https://stackoverflow.com/questions/72034607/can-i-change-storage-type-from-hdd-to-ssd-on-cloud-sql-after-creating-an-instanc

Enabling leader-aware routing ensures that your write traffic is automatically sent to the database's designated leader region rather than being round-tripped across regions. For a write- heavy workload in a multi-region configuration, this change cuts out cross-region hops and lowers latency far more effectively than adding indexes or nodes.

To keep disruption minimal while ensuring schema changes are replicated during an ongoing Database Migration Service (DMS) continuous migration for PostgreSQL, you should apply schema changes on the source using the pglogical.replicate_ddl_command extension so the DDL is propagated through logical replication to the destination automatically.

The Cloud SQL overprovisioned instance recommender helps you detect instances that are unnecessarily large for a given workload. It then provides recommendations on how to resize such instances and reduce cost. This page describes how this recommender works and how to use it. https://cloud.google.com/sql/docs/mysql/recommender-sql-overprovisioned#:~:text=The%20Cloud%20SQL%20overprovisioned%20instance%20recommender%20helps%20you%20detect%20instances%20that%20are%20unnecessarily%20large%20for%20a%20given%20workload.%20It%20then%20provides%20recommendations%20on%20how%20to%20resize%20such%20instances%20and%20reduce%20cost.%20This%20page%20describes%20how%20this%20recommender%20works%20and%20how%20to%20use%20it.