title: How to reduce the time to write pandas dataframes as table in Amazon Redshift
body: <p>I am writing python pandas data frame in Amazon Redshift using this -</p>
  
  <pre><code>df.to_sql('table_name', redshiftEngine, index = False, if_exists = 'replace' )
  </code></pre>
  
  <p>Although my dataframes have couple of thousand rows and 50-100 columns only, its taking 15-20 minutes to write one table. I wonder if that is normal performance in redshift ? Is there any way to optimize this process and speed up writing the table ?</p>