Redshift is a columnar database like BigQuery, so wouldn’t be based on an OLTP DB like Postgres. More I work for Google disclosures, but I think BQ kicks Redshifts butt.
Looks like I was mistaken. It uses some parts of postgres 8, but it is heavily modified. I agree Redshift isn’t that great though and it is super expensive for what you get. In the past when I have used Redshift I have not been that impressed.
Although one nice feature of Redshift is how well it works with other AWS services (COPY command from S3, firehouse can dump data into it, etc.)
