Re:Amazon RedShift vs. local PostgreSQL
by Whitespace on Friday February 15, 2013 @04:47PM
(#5228874)
Wouldn't it have been better to do an EXPLAIN ANALYZE for the timing measurements instead of having the results returned locally?
[ Parent
| on HN ]
Re:Amazon RedShift vs. local PostgreSQL
by fusiongyro on Friday February 15, 2013 @05:08PM
(#5228973)
It would certainly be interesting to see what Redshift returns when you do that.
Re:Amazon RedShift vs. local PostgreSQL
by rarestblog on Friday February 15, 2013 @05:07PM
(#5228963)
Honestly I don't know. Do you think it would be better? Could you explain why?
because it shows the estimated cost (plan) of the queries independent of the magically subtracted network roundtrip time. it also serves to show if the redshift even supports it.it.
Re:Amazon RedShift vs. local PostgreSQL
by rarestblog on Friday February 15, 2013 @05:23PM
(#5229053)
Ahhh, you meant on the RedShift side. I did not think of it. It would have definitely been better. Good point!
It seems that it actually supports it http://docs.aws.amazon.com/redshift/latest/dg/r_EXPLAIN.html