HAMY

Managed Postgres Database for less than $10 per month (Google CloudSQL)

Date: 2022-06-13 | google-cloud | database | postgres |

Cloud platforms provide loads of tools to build scalable software systems. Unfortunately, many of these tools can cost loads of cash to maintain if you're not careful.

In this post, I'm going to show you how to spin up a managed Postgres database on Google Cloud that costs less than $10 per month.

Table of Contents

CloudSQL

Managing your own servers can cost you a lot of time and headache. This often offsets any $ savings you have, particularly if you're running a small shop.

When it comes to databases, you don't want to get this tradeoff wrong. Data is the lifeblood of any company so corrupt / lost data can put you out of business.

CloudSQL helps with this by providing an easy way to spin up and maintain databases. It automates most of the maintenance so you never need to ssh into the machine - unless you want to.

$10 Postgres Database

Playing around with the [Google Cloud pricing page](https://cloud.google.com/products/calculator#id=2d8abbe9-115d-4cbe-97fb-6d00ed8c80c4, you can get a decently powered Postgres sql for < $10 per month.

  • SQL Instance Type: Shared Core - DB-F1-MICRO
  • Storage: 10 GB (SSD or HDD)
  • Backup: 10 GB

CloudSQL Performance Estimates

Scale Estimates:

  • Disk Throughput (MB/s):
    • Read: 4.8
    • Write: 4.8
  • IOPS:
    • Read: 300
    • Write: 300

While this can't handle huge load, it can scale quite well - definitely enough to handle a hobby project and typically enough to handle most early startup usage.

Deploy your Database

Now let's deploy your $10 Managed Postgres Database.

  • In your Google Cloud Project, go to Cloud SQL
  • Click Create Instance > Choose PostgeSQL
  • Configure your instance
    • Zonal Availability: Single Zone
    • Machine Type: Shared core - 1 vCPU, 0.614GB
    • Storage: SSD - 10GB
    • Backups: Automate Backups (costs an extra ~$2)

Wait a few minutes for the database to spin up and you're good to go!

Further Reading

Want more like this?

The best / easiest way to support my work is by subscribing for future updates and sharing with your network.