Hacker News Reader

Comment by formercoder | Hacker News Reader

I don’t know the details of Aurora, but AlloyDB separates compute and storage for Postgres. Masters can scale up and down with no downtime, and storage is provisioned in real time. Only pay for what you use. There is also a columnar engine cache, basically BigQuery, for OLAP queries.

View on HN

Interesting. Does it scale to zero like neon.tech supposedly can? Or does it always run a small daily fee of a few cents like Aurora? It wasn't immediately clear from the product page.

I don’t think so, from what I’ve seen it’s a premium price to Cloud SQL.

Yeah that is similar to Aurora. Basically a query engine on top of S3. Not sure if it is based on postgres or not though. It wouldn't shock me if it was as I know AWS Redshift is a forked version of postgres.

Redshift is a columnar database like BigQuery, so wouldn’t be based on an OLTP DB like Postgres. More I work for Google disclosures, but I think BQ kicks Redshifts butt.

https://stackoverflow.com/questions/34853204/is-aws-redshift...

Looks like I was mistaken. It uses some parts of postgres 8, but it is heavily modified. I agree Redshift isn’t that great though and it is super expensive for what you get. In the past when I have used Redshift I have not been that impressed.

Although one nice feature of Redshift is how well it works with other AWS services (COPY command from S3, firehouse can dump data into it, etc.)

Reply on news.ycombinator.com