How expensive is this compared to, for example AWS RDS?
Cloud SQL for PostgreSQL now generally available
11–20 of 108 posts
Re: Cloud SQL for PostgreSQL now generally available
#12Great news! This has been a long time coming (over a year since the beta started), looking forward to migrating my MySQL instances over.
Re: Cloud SQL for PostgreSQL now generally available
#13How do you deal with custom extensions (for example plv8)?
I started off with heroku and they don't support the same subset:
https://cloud.google.com/sql/docs/postgres/extensions
https://devcenter.heroku.com/articles/heroku-postgres-extens...
Re: Cloud SQL for PostgreSQL now generally available
#14Has anyone used the beta and got any feeling for how maintenance downtime impacts things? A bit nervous about how you can only set a "maintenance window" and not be able to plan ahead for disruption; as far as I can tell, they won't even tell you ahead of time. The HA seems really solid (zero-lag "regional disks"), but it's still a bit disconcerting.
The updates take the entire instance down for 2-5 minutes each month. While you can't avoid them, they can be scheduled for particularly low traffic times. If you're trying to avoid downtime, its a giant PIA. Even with HA enabled, you still lose master, slave and read replicas. Not entirely sure what they define HA as, but a mandatory monthly downtime doesn't usually fit into mine.
[Update] That said, from what I understand, they have a road map to maintaining read replicas and queued writes. Not sure what the date on it is though.
Re: Cloud SQL for PostgreSQL now generally available
#15How expensive is this compared to, for example AWS RDS?
The cost is virtually the same.
A db.t2.small instance should compare to a db-pg-g1-small instance. Pricing is around 90$ on AWS vs 93$ on GCP.
I’m an AWS consultant so I could have messed up on the GCP instance type.
Re: Cloud SQL for PostgreSQL now generally available
#16Great to see all three major cloud providers offering this now. Should be good for pricing!
Re: Cloud SQL for PostgreSQL now generally available
#17I'm looking around for more details on these "regional" disks that replicate between two zones at the block level. Is that just a fancy term for os level mirrored disks using the cloud persistent disks?
There's a previous blog post[1] about HA replication. It uses block-level replication managed by PD infrastructure.
[1] https://cloudplatform.googleblog.com/2017/11/Cloud-SQL-for-P...
Re: Cloud SQL for PostgreSQL now generally available
#18We actually just migrated off yesterday... we went with an independent vendor like Aiven instead of the clouds because they move too slowly and don't have enough features.
Like aiven or aiven? :) I’m not aware of too much competition in this space. We’re happy with aiven so far, but they’re quite unknown / under the radar it seems...
Re: Cloud SQL for PostgreSQL now generally available
#19Is point in time recovery available now in GA? I had checked it a couple of weeks ago for the beta service and it was not available. I think for a managed DB hosting point in time recovery is a critical feature.
Re: Cloud SQL for PostgreSQL now generally available
#20Will we be able to use the Citus extension? Been itching to get Citus running on GCP.
Does any major cloud provider support it?