Hacker News new | ask | show | jobs
by amalag 4868 days ago
You need to run this with a column store database like Infobright. Postgres is more of a transactional database, Infobright is suited towards the similar large dataset analytics that this is aimed towards.
1 comments

Redshift isn't Postgres. It's built on top of Postgres, similar to how Infobright is built on top of MySQL.
Redshift is built on ParAccel, not Postgres. It speaks the Postgres API, but the storage engine is not Postgres.
Some of the code is based on Postgres, based on their own marketing materials: "Paraccel has leveraged Postgres for some of its parsing and planning functions". So the head node continues to have Postgres origins, but not the compute nodes. Also see this write-up on their paper discussing the links to Postgres: http://dbmsmusings.blogspot.com/2009/07/paraccel-and-their-p...