Confirmed users
513
edits
Auto-tools/Projects/ActiveData/Redshift: Difference between revisions
Auto-tools/Projects/ActiveData/Redshift (view source)
Revision as of 04:57, 20 March 2015
, 20 March 2015add link
m (→Summary: fix typo) |
Klahnakoski (talk | contribs) (add link) |
||
| Line 11: | Line 11: | ||
'''Features we can use''' | '''Features we can use''' | ||
* Excellent query language based on Postgres 8 PSQL: [http://docs.aws.amazon.com/redshift/latest/dg/c_redshift-and-postgres-sql.html with some exceptions] | * Excellent query language based on Postgres 8 PSQL: [http://docs.aws.amazon.com/redshift/latest/dg/c_redshift-and-postgres-sql.html with some exceptions] | ||
* Excellent monitoring - | * Excellent monitoring - [http://docs.aws.amazon.com/redshift/latest/mgmt/metrics-listing.html see Amazon docs for summary] | ||
* No machine management – The machines supporting the database are wholly managed by Amazon. This is good because a lot of time can be sunk into managing the machines in the ES cluster. Redshift’s administrative tool allows you to grow and shrink the number of nodes, so you have some cost control, but we lose the ability to leverage the low priced spot instances. | * No machine management – The machines supporting the database are wholly managed by Amazon. This is good because a lot of time can be sunk into managing the machines in the ES cluster. Redshift’s administrative tool allows you to grow and shrink the number of nodes, so you have some cost control, but we lose the ability to leverage the low priced spot instances. | ||
* Can handle a billion records with ease | * Can handle a billion records with ease | ||