Introduction to Cloud SQL for PostgreSQL editions

MySQL | PostgreSQL | SQL Server

This page describes Cloud SQL editions and key features.

Cloud SQL offers the following editions to support your various business and application needs. Each edition provides different performance and availability characteristics to meet the needs of your applications.

Cloud SQL Enterprise edition: provides all core capabilities of Cloud SQL and is suitable for applications requiring a balance of performance, availability, and cost.
Cloud SQL Enterprise Plus edition: provides the best performance and availability to run applications requiring the highest level of availability and performance in addition to the capabilities of the Cloud SQL Enterprise edition.

Cloud SQL editions features

The following table provides an overview of the features available for each edition:

	Cloud SQL Enterprise edition	Cloud SQL Enterprise Plus edition
Pricing model	Cloud SQL Enterprise pricing	Cloud SQL Enterprise Plus pricing
Database versions	PostgreSQL 9.6, 10, 11, 12, 13, 14, 15, 16, 17	PostgreSQL 12, 13, 14, 15, 16, 17
Machine type	General-purpose machine family	Performance-optimized
Machine configuration limits	Up to 96 vCPU Up to 624 GB RAM 1:6.5 core:memory ratio	Up to 128 vCPU Up to 864 GB RAM 1:8 core:memory ratio
Availability SLA	99.95%	99.99%
Maintenance downtime	< 30 seconds	< 1 second
Data cache	No	Yes
Point-in-time log retention	Up to 7 days	Up to 35 days

Performance enhancements

Cloud SQL for PostgreSQL Enterprise Plus edition delivers enhanced read and write performance, and is ideal for applications that require maximum performance. This edition offers the following enhancements:

Improved read performance using data cache: Data cache leverages a fast, local SSD to store data pages that are read frequently. You can get up to three times improvement in read performance compared to reading from a persistent disk. Data cache is an optional feature and can be enabled during instance creation or after the instance has been created.
Enhanced write performance: Cloud SQL Enterprise Plus edition delivers up to two times the improvement in write latency. This makes it suitable for write-intensive applications requiring low latency and high throughput.
Engine autotuning: autotune engine configurations to match the capabilities of the underlying instance platform.

Availability enhancements

Cloud SQL Enterprise Plus edition provides the following major availability enhancements:

Advanced disaster recovery (DR): you can simplify recovery and fallback processes after you perform cross-region failover. With advanced DR, you can:
- Choose a cross-region disaster recovery (DR) replica
- Perform replica failover
- Restore your original deployment by using zero data loss switchover
For more information, see Advanced disaster recovery (DR) and Use advanced disaster recovery (DR).

Near-zero downtime: with Cloud SQL Enterprise Plus edition, you can maintain near-zero downtime for your instance when you perform any of the following management tasks:
- Perform or simulate a planned maintenance update event on a standalone primary instance
- Enable or disable data cache
- Scale up the compute size (vCPU, memory) of your Cloud SQL instance as many times you like
- Scale down the compute size (vCPU, memory) of your Cloud SQL instance once every three hours
  
  Note: If you scale down your instance more than once during a three-hour period, then only the first scale down event benefits from near-zero downtime. Subsequent scale down events experience regular downtime.
- Perform an in-place upgrade to Cloud SQL Enterprise Plus edition

Cloud SQL Enterprise Plus edition region support

The Cloud SQL Enterprise Plus edition supports the following regions:

africa-south1 — Johannesburg
asia-east1 — Taiwan
asia-east2 — Hong Kong
asia-northeast1 — Tokyo
asia-northeast2 — Osaka
asia-northeast3 — Seoul
asia-south1 — Mumbai
asia-south2 — Delhi
asia-southeast1 — Singapore
asia-southeast2 — Jakarta
australia-southeast1 — Sydney
australia-southeast2 — Melbourne
europe-central2 — Warsaw
europe-north1 — Finland
europe-southwest1 — Madrid
europe-west1 — Belgium
europe-west2 — London
europe-west3 — Frankfurt
europe-west4 — Netherlands
europe-west6 — Zürich
europe-west8 — Milan
europe-west9 — Paris
europe-west10 — Berlin
europe-west12 — Turin
me-central1 — Doha
me-central2 — Dammam
me-west1 — Tel Aviv
northamerica-northeast1 — Montréal
northamerica-northeast2 — Toronto
southamerica-east1 — San Paulo
southamerica-west1 — Santiago
us-central1 — Iowa
us-east1 — South Carolina
us-east4 — Northern Virginia
us-east5 — Columbus
us-south1 — Dallas
us-west1 — Oregon
us-west2 — Los Angeles
us-west3 — Salt Lake City
us-west4 — Las Vegas

Pricing

For more information about Cloud SQL editions pricing, see Cloud SQL pricing.

Cloud SQL editions FAQs

This section provides answers to frequently asked questions about Cloud SQL editions.

Does Cloud SQL Enterprise Plus edition support all engines?

Yes. Cloud SQL Enterprise Plus edition is supported on Cloud SQL for MySQL, Cloud SQL for PostgreSQL, and Cloud SQL for SQL Server.

How is Cloud SQL pricing changing?

Cloud SQL instances that you created before July 12, 2023, have become Cloud SQL Enterprise edition instances with no change in features or pricing. Instances created after July 12, 2023 can be either Cloud SQL Enterprise edition or Cloud SQL Enterprise Plus edition.

Cloud SQL Enterprise Plus edition has a new pricing structure. For more information about Cloud SQL pricing, see Cloud SQL pricing.

What can I do to prepare for these changes?

You can create Cloud SQL Enterprise Plus edition and Cloud SQL Enterprise edition instances in regions where supported using Google Cloud console and gcloud CLI.

Can I mix and match editions?

Yes, you can. Cloud SQL Enterprise Plus edition and Cloud SQL Enterprise edition provide different levels of database performance availability and data protection capabilities. You can select the Cloud SQL editions that best meets your varying application needs.

Can I migrate between editions?

By using in-place upgrade, you can upgrade your instances to Cloud SQL Enterprise Plus edition with near-zero downtime or switch to Cloud SQL Enterprise edition.

You can move your instances between Cloud SQL Enterprise edition and Cloud SQL Enterprise Plus edition with Database Migration Service using the following two ways: