How to execute Redshift queries in parallel

Question

I need to simulate some basic load testing against my Redshift cluster and I need to execute around 20 SELECT queries in parallel.

Since stored procedures are not supported by Redshift, I would love to get some ideas on how I can accomplish this.

Query Queue in work load management? – Ranadip Dutta Nov 20 '17 at 13:55 — Ranadip Dutta, Nov 20 '17 at 13:55

score 1 · Answer 1 · answered Nov 20 '17 at 14:10

1

answered Nov 20 '17 at 14:10

Ranadip Dutta

score 1 · Accepted Answer · answered Nov 20 '17 at 14:18

1

To initiate the selects in parallel, install this

and then you can run parallel sql commands against redshift like this

export PGPASSWORD=your_pw; par_psql -h your_redshift -p 5439 -U your_username -d mydb —-file=myscript.sql

answered Nov 20 '17 at 14:18

Jon Scott

2 Answers2