Redshift is definitely "based" on Postgres, but its distributed systems components are probably proprietary enough that the concern is valid.
Re:Jepsen: Crate 0.54.9 version divergence
by spooneybarger on Tuesday June 28, 2016 @09:29PM
(#11998908)
Redshift is based on tech from ParAccel.
RedShift technically is a service for which you pay not a database (I did not use it but I believe it is Postgres - don't quote me on that), so if it doesn't provide what's promised you take it with Amazon.
Anyway the summarize databases. Currently we have two types:
- relational databases - old and proven, always consistent, but typically not distributed
- so called NoSQL which I think only worth attention are AP (from the CAP). These databases scale, but are eventually consistent. This means they are consistent most of the time, but not always. It's good for storing things that while important, it's acceptable when some individual entries are wrong or lost (user sessions, shopping carts, tracked information about users etc)
There are also databases like Mongo which are snake oil.