3 ms·

edit: My original comment's data was misleading due to conversion error. I edited out the comment to avoid confusion for anyone else who might not spot the erro

edit: My original comment's data was misleading due to conversion error. I edited out the comment to avoid confusion for anyone else who might not spot the error and be misinformed. Thank you for those who pointed it out!

mej10 10y ago
> and a DC1.8XL costs $4800/hour to "compute" the data. Is this a typo? A single DC1.8XL is $4.80/hour. 8, like the article, would be $38.40/hour.
- mooman219 10y ago
  As stated, on demand pricing was used. Both products have special pricing at higher usages and flat-pricing tiers. It would start to get compilicated to compare them at that point. Numbers on https://aws.amazon.com/redshift/pricing/ https://aws.amazon.com/redshift/pricing/ used. dc1.8xlarge - $4.800 per Hour
  - deleted 10y ago
    [deleted]
  - zerocrates 10y ago
    > $4.800 per Hour That's four point eight dollars, not four thousand eight hundred.
    - mooman219 10y ago
      Fixed! Used to seeing 4.800 being 4800 apologies!
      - zerocrates 10y ago
        I figured. It's easy to forget that there's really no international/intercultural agreement on number punctuation, particularly combined with a service that wants to price down to tenths of cents.
  - mej10 10y ago
    I don't understand how you calculated how much it costs to compute on the Redshift cluster. $1100 would be ~28 hours of the 8-node cluster.
manigandham 10y ago
You're math is wrong - DC1.8XL costs $4.80 per hour, not $4800 (which would be ridiculous pricing). 8 instances of DC1.8XL = $38.4 which means you can run the redshift cluster for 28 hours (edit: for $1100, which is the cost of scanning 220TB of data with BQ, used in previous comment). Redshift does win on price when you are continuously running queries and scanning entire datasets, although there is enterprise pricing available for BQ if you hit a certain amount.
- mooman219 10y ago
  Completely correct! I apologize, used to seeing a different notation and the extra 0 in 4.800 threw me off. I removed the misleading data because judging by the points, not everyone caught it.
- cobookman 10y ago
  BQ offers a flat rate pricing package now. https://cloud.google.com/bigquery/pricing#flat_rate_pricing https://cloud.google.com/bigquery/pricing#flat_rate_pricing
  - manigandham 10y ago
    That's what I meant by enterprise pricing.

mej10 10y ago

> and a DC1.8XL costs $4800/hour to "compute" the data. Is this a typo? A single DC1.8XL is $4.80/hour. 8, like the article, would be $38.40/hour.

mooman219 10y ago
As stated, on demand pricing was used. Both products have special pricing at higher usages and flat-pricing tiers. It would start to get compilicated to compare them at that point. Numbers on https://aws.amazon.com/redshift/pricing/ https://aws.amazon.com/redshift/pricing/ used. dc1.8xlarge - $4.800 per Hour
- deleted 10y ago
  [deleted]
- zerocrates 10y ago
  > $4.800 per Hour That's four point eight dollars, not four thousand eight hundred.
  - mooman219 10y ago
    Fixed! Used to seeing 4.800 being 4800 apologies!
    - zerocrates 10y ago
      I figured. It's easy to forget that there's really no international/intercultural agreement on number punctuation, particularly combined with a service that wants to price down to tenths of cents.
- mej10 10y ago
  I don't understand how you calculated how much it costs to compute on the Redshift cluster. $1100 would be ~28 hours of the 8-node cluster.

manigandham 10y ago

You're math is wrong - DC1.8XL costs $4.80 per hour, not $4800 (which would be ridiculous pricing). 8 instances of DC1.8XL = $38.4 which means you can run the redshift cluster for 28 hours (edit: for $1100, which is the cost of scanning 220TB of data with BQ, used in previous comment). Redshift does win on price when you are continuously running queries and scanning entire datasets, although there is enterprise pricing available for BQ if you hit a certain amount.

mooman219 10y ago
Completely correct! I apologize, used to seeing a different notation and the extra 0 in 4.800 threw me off. I removed the misleading data because judging by the points, not everyone caught it.
cobookman 10y ago
BQ offers a flat rate pricing package now. https://cloud.google.com/bigquery/pricing#flat_rate_pricing https://cloud.google.com/bigquery/pricing#flat_rate_pricing
- manigandham 10y ago
  That's what I meant by enterprise pricing.