Redshift Spectrum – Exabyte-Scale In-Place Queries of S3 Data
This seems really slow for queries especially when taking into account all the computing power being thrown at it:<p>Over 6 billion rows (not huge by modern standards), a relatively common aggregation query with 4 basic aggregates (2 sum, 2 avg), one where, and two group by clauses, over 1 table (no joins) takes about 4.25 minutes (254.650 seconds).<p>On some column databases on good hardware with a single machine you can probably get a couple seconds, probably faster.