Aurora announced support for parallel queries[1] for MySQL, with Postgres coming soon.

(I work at AWS but not RDS/Aurora)

  [1] https://aws.amazon.com/blogs/aws/new-parallel-query-for-amazon-aurora/