title: Does adding sort keys to Redshift table speed up delete statements?
body: <p>I have a very large table in Redshift with ~36M rows that uses composite keys. I am trying to perform massive delete + copying (S3 copy command) operations every half minute. We have an ETL pipeline that tries to update our data warehouse tables near real-time. Currently I am using psycopg2's <code>executemany</code> method to delete rows, this method basically batches up my delete queries and performs many small</p>
  
  <pre><code>delete from table where col1=val1 and col2=val2 ...
  </code></pre>
  
  <p>in a for loop (I am probably over-simplifying the implementation). If I altered my table to make the composite keys into sortkeys, would this speed up my deletes?</p>