3 ms·
Every talk AWS does about Redshift they mention that it’s based on Postgres. They tell you to download a Postgres driver to connect to it with any language besi
by scarface74 6y ago
Every talk AWS does about Redshift they mention that it’s based on Postgres. They tell you to download a Postgres driver to connect to it with any language besides Java for which a JDBC driver is provided.
- atonse 6y agoWell ... they tell you that not because they're bending over backwards to give postgres credit. They're doing it to tell you that the barrier of entry to this database is nearly 0 if you are already using Postgres.
- scarface74 6y agoYou haven’t watch the reInvent talks have you? But if you try to use the same schema design from a standard Postgres database and use the same query patterns, you will be sorely disappointed. Redshift uses a columnar store and is an OLAP database as opposed to Postgres which is a traditional database.
- bdcravens 6y agoYou can implement a columnar store in Postgres. (Of course there's more to Redshift than that) https://github.com/citusdata/cstore_fdw https://github.com/citusdata/cstore_fdw
- atonse 6y agoNo I totally get that. It is designed for data warehousing workloads rather than transactional. I'm saying that I have seen it more as a feature of "you use your existing tools and drivers" since it speaks the postgres wire protocol.
- bdcravens 6y agoI agree, but I was trying to be apples to apples and compare launch announcements, and when Redshift was announced, the discussion of Postgres was quite muted (admittedly several years ago, so their messaging may have shifted over time)