Redshift

What do you like best?

Redshift is a fork off of Postgres and the engineers at amazon have made many improvements to scale the capabilities of Redshift to accommodate voluminous data. Redshift also works with AWS S3 to perform parallel inserts into the data warehouse tables. Redshift also allows for table optimization due to the specification of sort and distribution keys when writing the DDL of your tables. Additionally, spinning up a cluster is super simple via the aws console.

What do you dislike?

Reading the documents can take some time but it will definitely be worth your time. Finding the nitty gritty details of how certain things work is buried inside mountains of documentation and there are not many examples to draw inspirations from.

What problems are you solving with the product? What benefits have you realized?

Redshift is for handling storing and analyzing massive amounts of data