Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

Cloud SQL for PostgreSQL now generally available

cloudplatform.googleblog.com

Post reply on HN
Print view View original

81–90 of 108 posts

Re: Cloud SQL for PostgreSQL now generally available

#81

Post by gingerlime »

manigandham wrote: post #21
gingerlime wrote: post #18

Earlier quoted context omitted.

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...

They're the best we've found as well, but there are lots of managed database providers of all kinds. https://www.compose.com is another big one.

We’re using compose for redis, but we might switch it to aiven as well, despite aiven having some missing functionality...

For Gcloud and especially in Europe, I think these two are the only options that I’m aware of (at least for PG and redis)

Re: Cloud SQL for PostgreSQL now generally available

#82

Post by renchap »

tacticus wrote: post #73
flamingcow wrote: post #50

Earlier quoted context omitted.

[I'm the Cloud SQL TL] No, it isn't. We agree with you that it's an important feature for managed databases, and we're working to get it right. We decoupled it from this launch to get PostgreSQL to GA faster.

Unrelated to pg but could you badger the spanner team to make a mini spanner product :) Related to postgres. We have many many concurrent connections but a load satisfied by an n1-standard-4 atm do you recommend a connection pooler or something to help us get down to the 100 to 200 connections we need to be at to use cloudsql?

Connection pooling is recommended for any non-trivial PG deployment. I can recommend pgbouncer, worked flawlessly for us.

Re: Cloud SQL for PostgreSQL now generally available

#83

Post by ngrilly »

sudhirj wrote: post #80
optimusclimb wrote: post #59

Started down the path of using this when it was in beta, but had to abort when we saw there was no option to connect to it from Python App Engine Standard. Now that it's GA...it looks like that hasn't changed. Is the classic, Python, App Engine standard becoming a second class citizen? Or was there some reason why this wasn't considered GA worthy for Postgres? Trying to understand if going forward Google is trying to…

I wouldn't say second class citizen (just yet) but the docs and Googlers have been gently nudging people to the flex environment. It can do everything the standard one does and more, so there's really very little reason to stick around on standard.

Cost maybe?

Re: Cloud SQL for PostgreSQL now generally available

#84

Post by dvdgsng »

brdd wrote: post #65
kdv wrote: post #25

Does anyone have insight or experience using this in production? We're currently running PostgreSQL 10 w/ pg_partman on our own hardware but looking at a several options for cloud migration. Unfortunately, Citus Cloud on GCP doesn't appear to be an option (yet?) - Google Cloud SQL (PostgreSQL) - Citus Cloud (AWS Only) - Citus (managed ourselves) on GCP

We've been running a production workload on Postgres/Google Cloud SQL for about half a year now. While things are good for the most part, a couple of serious problems related to connectivity have us completely boggled. We're connecting from Google Kubernetes Engine, which seems like it should be a standard combination, but run into constant problems that we've dumped many many hours into debugging. We still haven't f…

Could you elaborate a bit on the connectivity problems? What is your setup? CloudSQL Proxy, any loadbalancers?

Re: Cloud SQL for PostgreSQL now generally available

#85

Post by ngrilly »

flamingcow wrote: post #53
daj40 wrote: post #14

Earlier quoted context omitted.

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 und…

[I'm the Cloud SQL TL] I can't comment on timelines, but we're aware that customers are interested in more features around maintenance window scheduling, deferral, and notification, as well as shorter downtime for updates and smarter scheduling within a group of replicas.

What's the point of HA if there is a still a maintenance downtime?

Re: Cloud SQL for PostgreSQL now generally available

#86

Post by vtainio »

napsterbr wrote: post #41
contrahax wrote: post #23

Earlier quoted context omitted.

They don't have a great story around extensions - the ones they do have are unsupported/buggy. For example, PostGIS is missing "ST_FromGeoJSON" because it was compiled with the wrong flag - and has been this way for over a year despite hundreds of user complaints.

As someone who was migrating from on-premises to gcp, and who needs extensive postgis support, this information is a deal breaker for me. Is there any place I can find more information about postgis and other extensions status? Are you aware of any other bug related to postgis? Thanks a lot for the information

Aiven (https://aiven.io/postgresql) supports PostGIS on GCP if you are looking for an alternative choice.

Re: Cloud SQL for PostgreSQL now generally available

#87

Post by merb »

sudhirj wrote: post #80
optimusclimb wrote: post #59

Started down the path of using this when it was in beta, but had to abort when we saw there was no option to connect to it from Python App Engine Standard. Now that it's GA...it looks like that hasn't changed. Is the classic, Python, App Engine standard becoming a second class citizen? Or was there some reason why this wasn't considered GA worthy for Postgres? Trying to understand if going forward Google is trying to…

I wouldn't say second class citizen (just yet) but the docs and Googlers have been gently nudging people to the flex environment. It can do everything the standard one does and more, so there's really very little reason to stick around on standard.

Well if they provide a free tier for flex, that is equal to standard, I wouldn't bother switching.

Re: Cloud SQL for PostgreSQL now generally available

#88

Post by craigkerstiens »

kdv wrote: post #25

Does anyone have insight or experience using this in production? We're currently running PostgreSQL 10 w/ pg_partman on our own hardware but looking at a several options for cloud migration. Unfortunately, Citus Cloud on GCP doesn't appear to be an option (yet?) - Google Cloud SQL (PostgreSQL) - Citus Cloud (AWS Only) - Citus (managed ourselves) on GCP

Hi, Craig from Citus here. If you're interested in Citus being available on other infrastructure provides aside from AWS as a fully managed service please feel free to reach out to me directly craig at citusdata.com.

Re: Cloud SQL for PostgreSQL now generally available

#89

Post by sirn »

Since there seems to be some Googler who work on Cloud SQL here, I wonder is there any chance Cloud SQL will be available in asia-southeast1 soon? It's the only region (I believe) where Cloud SQL isn't available at all, and one of the main reasons we can't fully migrated from AWS to GCP just yet.

Re: Cloud SQL for PostgreSQL now generally available

#90

Post by kdv »

manigandham wrote: post #35
kdv wrote: post #25

Does anyone have insight or experience using this in production? We're currently running PostgreSQL 10 w/ pg_partman on our own hardware but looking at a several options for cloud migration. Unfortunately, Citus Cloud on GCP doesn't appear to be an option (yet?) - Google Cloud SQL (PostgreSQL) - Citus Cloud (AWS Only) - Citus (managed ourselves) on GCP

We did, but now use https://aiven.io Highly recommended if you want a fast and featured managed db service.

Interesting. I'm curious how they compare to Citus and if there are any tight integrations with their over services (managed Kafka or Elasticsearch)
Post reply on HN