3 ms·
Well ... 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 d
by atonse 6y ago
Well ... 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.