We are planning an in-place major version upgrade of a Cloud SQL for PostgreSQL instance from PostgreSQL 11 to PostgreSQL 15.
The database is approximately 130 GB in size, and we would like to estimate the expected application downtime during the upgrade.
Could you please help clarify:
- What is the typical or expected downtime for an in-place PostgreSQL 11 → 15 major version upgrade for a database of approximately 130 GB?
- Is the downtime primarily dependent on the database size, or are there other factors that significantly affect the upgrade duration?
- Does Cloud SQL use a process similar to
pg_upgrade, and is the database unavailable for the entire duration of the upgrade? - Is there any way to estimate or benchmark the expected downtime before performing the production upgrade?