Alright, you just can't help yourself, can you? Unfortunately, now I have to defend myself.
I have no doubt that the Redshift SQL parser and other SQL statement processing logic is highly based on open source Postgres, partially for application compatibility, partially because Postgres is the best open source DBMS (IMO), and because Postgres is distributed using a very liberal license which allows Amazon to modify and distribute products based on all or portions of Postgres code without paying any fees or commitments to contribute their modifications to the Postgres project:
www.postgresql.org
BTW, I made a mistake in a previous post. Amazon did not acquire ParAccel, they purchased a license to the code a long time ago. I keep forgetting that.
Redshift has four competitive advantages over Postgres I'm aware of:
1. Scale-out architecture. ParAccel was a scale-out product, Postgres still doesn't support scale-out. And ParAccel supported native scale-out processing, not the less efficient SQL-to-SQL rewriting with database instances that are not scale-out aware, like some scale-out databases do. Redshift has native scale-out.
2. Compiled queries. This was a key feature of ParAccel. Rather than interpreting the steps of a query plan, Redshift produces a custom program and compiles it to assembler code. The savings in CPU time can be considerable for complex queries. Postgres doesn't compile queries either.
3. Amazon uses a custom-written storage subsystem for its databases, which takes advantage of its cloud storage architecture and Amazon hardware. Even the Aurora version of Postgres does this.
4. Custom Graviton-based processing hardware. RA3 nodes. Note the reference to AGUA.
Amazon Redshift is a fully managed, petabyte-scale data warehouse service in the cloud. You can start with just a few hundred gigabytes of data and scale to a petabyte or more. This enables you to use your data to acquire new insights for your business and customers. Over the years, Amazon...
aws.amazon.com
I'm sure the current version of the Redshift code has little resemblance if any to the original ParAccel code from ten years ago, but "based on Postgres" is a misstatement, even if it is on the Amazon site.