4 ms·
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
by amalag 14y 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.
- scotth 14y agoRedshift isn't Postgres. It's built on top of Postgres, similar to how Infobright is built on top of MySQL.
- zwily 14y agoRedshift is built on ParAccel, not Postgres. It speaks the Postgres API, but the storage engine is not Postgres.
- scw 14y agoSome 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-puzzling-tpc-h.html http://dbmsmusings.blogspot.com/2009/07/paraccel-and-their-p...