7 ms·
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 provi
by formercoder 4y ago
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.
- makestuff 4y agoYeah 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.
- formercoder 4y agoRedshift 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.
- makestuff 4y agohttps://stackoverflow.com/questions/34853204/is-aws-redshift-to-postgresql-the-same-as-aws-aurora-to-mysql 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.)
- Vt71fcAqt7 4y agoInteresting. 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.
- formercoder 4y agoI don’t think so, from what I’ve seen it’s a premium price to Cloud SQL.