3 ms·
You can't really shut down and restart a Redshift cluster on-demand, since they take hours to start up on a larger dataset. So you should take the standard pric
by MichaelBurge 10y ago
You can't really shut down and restart a Redshift cluster on-demand, since they take hours to start up on a larger dataset. So you should take the standard pricing and assume it's running 24/7(maybe you can shut it down on weekends or on holidays).
Last I looked, that was something like $7500/year on-demand for a single 2TB node. Multiply that by the number of nodes you need to store your data. Probably you'll want to prepurchase a year to get the better pricing and tax benefits; I think that brings it down to $5000/year.
- bsg75 10y agoHours to start up? On what size dataset does that start to become the case? Been experimenting with BigQuery, and interested in how pricing compares: Usage vs instance based.
- MichaelBurge 10y agoThe one I had in mind was about 50TB. A year ago, that would take up to 17 hours from startup to be 'fully available'(I think it prioritizes which tables to load based on how you query them). I haven't worked with it since; Amazon may have improved the startup times. We were thinking about trying BigQuery at one point since the pricing matched our usage better, but Redshift was good enough. The concern there was that Redshift was similar enough to Postgres we could use our existing database libraries, while BigQuery was some entirely custom protocol that didn't have a Perl SDK.
- krmmalik 10y agoGreat. Thanks