Source: feedproxy.google.com

New – Parallel Query for Amazon Aurora

Category: Amazon

The instance class determines the number of parallel queries that can be active at a given time:db.r*.large – 1 concurrent parallel query session– 1 concurrent parallel query session db.r*.xlarge – 2 concurrent parallel query sessions– 2 concurrent parallel query sessions db.r*.2xlarge – 4 concurrent parallel query sessions– 4 concurrent parallel query sessions db.r*.4xlarge – 8 concurrent parallel query sessions– 8 concurrent parallel query sessions db.r*.8xlarge – 16 concurrent parallel query sessions– 16 concurrent parallel query sessions db.r4.16xlarge – 16 concurrent parallel query sessionsYou can use the aurora_pq parameter to enable and disable the use of parallel queries at the global and the session level.
Parallel queries enhance the performance of over 200 types of single-table predicates and hash joins.
Parallel Query in ActionYou will need to create a fresh cluster in order to make use of the Parallel Query feature.
To create a cluster that supports Parallel Query, I simply choose Provisioned with Aurora parallel query enabled as the Capacity type:I used the CLI to restore a 100 GB snapshot for testing, and then explored one of the queries from the TPC-H benchmark.
Cost – You can make use of Parallel Query at no extra charge.