Amazon RedShift vs. local PostgreSQL
rarestblog.com
Amazon RedShift vs. local PostgreSQL
1–10 of 34 posts
Re: Amazon RedShift vs. local PostgreSQL
#2very interesting. one of the reasons we picked mysql for a very high-volume app over postgres is that we have RDS and didn't want to do backups/snapshots/etc. Could we now use RedShift as a postgres-API RDS?
Re: Amazon RedShift vs. local PostgreSQL
#3Wouldn't it have been better to do an EXPLAIN ANALYZE for the timing measurements instead of having the results returned locally?
Re: Amazon RedShift vs. local PostgreSQL
#4I'd like to see some more information about the local setup, including hardware and the postgresql.conf. Otherwise, this tells me very little in terms of comparison.
Re: Amazon RedShift vs. local PostgreSQL
#5I'd like to see some more information about the local setup, including hardware and the postgresql.conf. Otherwise, this tells me very little in terms of comparison.
In anyway this test won't tell you much, just how different systems behave to bigger load.
The local setup was quite usual: PostgreSQL 9.2, Mint 13, default conf in VirtualBox in iMac i5 12GB. (read: home computer, no tuning)
For me the result is that mostly RedShift is on par with local PostgreSQL, sometimes even winning for Also the big deal was that RedShift scaled linearly.
Re: Amazon RedShift vs. local PostgreSQL
#6Wouldn't it have been better to do an EXPLAIN ANALYZE for the timing measurements instead of having the results returned locally?
Honestly I don't know. Do you think it would be better? Could you explain why?
Re: Amazon RedShift vs. local PostgreSQL
#7Wouldn't it have been better to do an EXPLAIN ANALYZE for the timing measurements instead of having the results returned locally?
It would certainly be interesting to see what Redshift returns when you do that.
Re: Amazon RedShift vs. local PostgreSQL
#8This is a pretty interesting. I wonder how query performance differs between Redshift and local PostgreSQL for other types of benchmarks as well, say TPC-H queries. (And I guess how Redshift scales out as the dataset size increases in TPC-H.)
Re: Amazon RedShift vs. local PostgreSQL
#9I run 3 large oracle RDS instances I wonder if redshift could be effectively used the same way, we have been thinking about migrating to postgresql.
Re: Amazon RedShift vs. local PostgreSQL
#10Data warehousing often involves star schemas, which means lots of joins in your queries. I'd love to see how a real world OLAP tool performs on this.