Rules and Guidelines for Configuring Amazon Redshift Workload Management
Rules and Guidelines for Configuring Amazon Redshift Workload Management
Consider the following rules and guidelines when you configure the Amazon Redshift Workload Management interface:
Separate the data import jobs from the analysis queries and ensure that the jobs have the resources that they need to complete the queries.
For non-ETL queries, you must set the default concurrency as five and assign sufficient memory to the concurrent analytic query jobs.
You must separate the queues for batch jobs, adhoc queries, and interactive queries.
You must separate the queues for ETL jobs.
You must separate the queues for short and long running ETL jobs. The lower the concurrency of long running ETL jobs, specify a lower memory while short running ETL jobs can have concurrency lesser than one.