News for hackers. Stuff that matters.
Re:Google Cloud SQL for Postgres by ozgune on Thursday March 09, 2017 @03:58PM (#13833550)
(Ozgun from Citus)

As someone who interacts with PostgreSQL on-prem and cloud deployments frequently, I'm curious on the Hacker News community's thoughts on one question.

AWS has a fairly mature RDS Postgres offering. What would motivate you to use Google Cloud Postgres instead?

I've heard of four reasons from users: not on AWS, don't want to be locked into one vendor, cost, and better support. Do any of these reasons resonate with you or are there others?

Re:Google Cloud SQL for Postgres by michael-go on Thursday March 09, 2017 @04:19PM (#13833772)
What motivates me personally is not that I think Google Postgres will be better than RDS (which is great for us so far), but because I want to move to GCP for other reasons (pricing, better UI & cli, GKE, BigQuery) and the managed Postgres RDS was the only thing that was important enough to keep us on AWS
Re:Google Cloud SQL for Postgres by mhluongo on Thursday March 09, 2017 @05:44PM (#13834531)
Same for us. We're migrating to GKE but are accessing Postgres over a gateway and leaving our DB heavy services on AWS... This was very good news.
Re:Google Cloud SQL for Postgres by sandGorgon on Thursday March 09, 2017 @10:17PM (#13836054)
Same here.

Plus RDS was the only reasonable option at that price tier (with high availability and multi-AZ). I think competition was sorely needed.

RDS was pretty much becoming a monopoly on this front.

Re:Google Cloud SQL for Postgres by bruce_one on Friday March 10, 2017 @05:45AM (#13837675)
Is [Compose](www.compose.com) comparable?

They have a HA postgres offering (not sure about multi-az) and I thought I'd heard good things about them in the past?

Re:Google Cloud SQL for Postgres by JoeyPeeps on Friday March 17, 2017 @02:12PM (#13896435)
I just started using Google Postgres and, as of today, there is no way to easily get your PG data into BigQuery via any Google cloud service. You have to create your own CSV from your PG data, then upload that into BigQuery. I imagine (hope) this will change with additions to the Export options of PG instances.
Re:Google Cloud SQL for Postgres by cdnsteve on Thursday March 09, 2017 @05:14PM (#13834312)
I'd consider Google Cloud because the documentation, tutorials and verbose config (on most services) on AWS are a fairly substantial barrier. Has you ever gone through trying to wire up a Lambda function to talk to a S3 bucket and API getway endpoint? It's not fun. Even getting ElasticBeanstalk running with Docker isn't really easy.

I think Google Cloud is the middle ground between Heroku and AWS. It has potential to really gain traction with developers who want to get stuff shipped and not wear DevOps hats full time. What I'd like to see is Google adopting more modern software on their platform (Python 3) and trying to move things out of beta more quickly. You can't sell beta to management easily.

Re:Google Cloud SQL for Postgres by sjellis on Friday March 10, 2017 @02:36AM (#13836992)
I'd consider Google Cloud because the documentation, tutorials and verbose config (on most services) on AWS are a fairly substantial barrier. Has you ever gone through trying to wire up a Lambda function to talk to a S3 bucket and API getway endpoint? It's not fun.

Strongly agree. I think that using an orchestration tool like Ansible or Cloud Formation is basically essential for AWS, because so many of the services have these interdependencies.

> Even getting ElasticBeanstalk running with Docker isn't really easy.

Yeah, we tried it. Not a great experience, and using an AWS proprietary container hosting system when everyone else is standardising on Kubernetes is not remotely attractive. I'm really looking forward to trying App Engine Flexible and GKE. If we can get really good application container hosting from GCP, then that will be a strong pull to migrating whole stacks.

Re:Google Cloud SQL for Postgres by tracker1 on Thursday March 09, 2017 @11:56PM (#13836483)
I'd say the Elastic Beanstalk with a single container is very easy... zip your project with a Dockerfile, and it will create the container...

However, man that Awsrunfile or whatever it is called, and the two versions that are incompatible with the different EB versions, and it's painful... the hosted container solution equally so.

GC's docs and tools just seem so much more straight forward (as do Azure's for that matter).

Re:Google Cloud SQL for Postgres by matrix on Thursday March 09, 2017 @04:39PM (#13833976)
There are lots of reasons to prefer Google, but ultimately there is one, single reason I want to switch:

The ability to cap costs.

With AWS, by the time you get a billing alarm, you could be thousands of dollars in the hole and there's nothing you can do about it. Avoiding that risk will help me sleep a little better.

Re:Google Cloud SQL for Postgres by dragonwriter on Friday March 10, 2017 @12:12AM (#13836555)
I thought GCloud only had spending limits for App Engine services (including, apparently, Cloud Datastore even when used separately from App Engine), but not other services.
Re:Google Cloud SQL for Postgres by matrix on Friday March 10, 2017 @05:58PM (#13842881)
Thanks for alerting me to that possibility. If that's the case (can anyone confirm for sure?) then switching is probably not worth the switching costs for me right now.
Re:Google Cloud SQL for Postgres by theptip on Thursday March 09, 2017 @04:18PM (#13833765)
As a Google customer (of both Compute/Container Engine and Cloud SQL), I'd rather use a Mysql instance hosted next to my application on Google's network than a Postgres instance that's an internet-hop away in Amazon's cloud. If I was currently running my apps on AWS that's where my DB would live too (and I'd be using RDS Posgres there).

The other reasons listed are an order of magnitude less important for my cost/benefit calculus (though things like cost and support will definitely matter to orgs bigger than mine).

Re:Google Cloud SQL for Postgres by no1youknowz on Thursday March 09, 2017 @05:18PM (#13834356)
Yes, costs is a big factor for me.

I would love to see your own cloud offerings on Digital Ocean and on Google Cloud. Hopefully, with that said, we'll also see much more reasonable pricing as well!

Re:Google Cloud SQL for Postgres by craigkerstiens on Thursday March 09, 2017 @06:06PM (#13834685)
I'm curious what you'd like to see in terms of pricing from Citus?

Yes, we do start at a higher end $990 a month, but we're very much focused on heavier workloads. Typically users come to us at 100 GB or more. If you're well below that we encourage you to stick with single node Postgres either RDS or Heroku Postgres. Once you get close to a $1k a month spend on those then we can start to make sense to consider.

Re:Google Cloud SQL for Postgres by sandGorgon on Thursday March 09, 2017 @10:19PM (#13836068)
A multi node , 100gb postgres cluster can be had for 260$ per month if you choose yearly prepaid on RDS.

The price to performance ratio is fairly unbeatable.

Re:Google Cloud SQL for Postgres by craigkerstiens on Thursday March 09, 2017 @11:08PM (#13836298)
Price to performance is a bit debatable.

Yes, you can absolutely get that much storage for that price. Though what your application needs in terms of memory/cores varies quite a bit on the application. We've seen customers that were spending $800 a month on RDS, migrate and get 2-3x performance boost for the same dollar spend.

Don't disagree at all that if you're at a lower volume of data that RDS is a great option for what you get. Depending on your application needs though as you scale and need more data in cache or more cores doing work, though this all depends on your workload. You can have 3 TB of cold storage and that work fine for your application and cost you under $1k a month on Aurora, or you could have needs with 100 GB of data that you need all queries served from cache in milliseconds. It's very unlikely you'll get that for $260 a month on RDS even at as little of 100 GB of data. It just depends on your application workload, for as long as you can you should just keep scaling up because it's much easier.

We very much focus on when you start to encounter that ceiling where scaling up starts to become prohibitive and performance is key not just storage–which can be as early as 100 GB, and is increasingly common the further you get beyond that.

Re:Google Cloud SQL for Postgres by sandGorgon on Friday March 10, 2017 @01:22AM (#13836777)
which im agreeing on - I was trying to hint to make a tier for the 200$ users out there ;)
Re:Google Cloud SQL for Postgres by philliphaydon on Thursday March 09, 2017 @08:29PM (#13835574)
I use PostgreSQL on RDS. I wouldn't touch GCE for a year still it's had its kinks ironed out.