CODEWITHSUNDEEP
postgresqlgoogle-cloud-platformgoogle-cloud-sql
Thomas
Thomas

Reputation: 182048

How can I create a PostgreSQL db-f1-micro instance?

In the Cloud SQL for PostgreSQL pricing examples, I see that I should be able to create a db-f1-micro instance, using a shared CPU and 0.6 GB of RAM, at the price of $9/month.

However, when I try to actually create such an instance, I don't see that option. The UI only allows me to create a custom machine type with at least 1 vCPU and 3.75 GB of RAM, which would cost $51/month:

Screenshot of Cloud Console creating a PostgreSQL instance

Interestingly, for MySQL, I do get the option to create a db-f1-micro instance. But I can't use MySQL for this project.

Are the docs in error here? Or is there a trick to actually creating a budget db-f1-micro instance using PostgreSQL?

Upvotes: 12

Views: 4251

Answers (2)

Alexey Leshchenko
Alexey Leshchenko

Reputation: 143

Also you can change it with CLI via gcloud:

gcloud sql instances patch <instance name here> --tier db-f1-micro

Upvotes: 2

Thomas
Thomas

Reputation: 182048

Aha, I was missing a trick: the Cores slider isn't all the way on the left! Dragging it down sets it to "1 shared vCPU" and changes the memory settings to my satisfaction:

Screenshot of vCPU setting

Upvotes: 21

Related Questions