title: Loading data to Postgres RDS is still slow after tuning parameters
body: <p>We have created a RDS postgres instance (m4.xlarge) with 200GB storage (Provisioned IOPS). We are trying to upload data from company data mart to the 23 tables in RDS using DataStage. However the uploads are quite slow. It takes about 6 hours to load 400K records. </p>
  
  <p>Then I started tuning the following parameters according to <a href="http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_BestPractices.html#CHAP_BestPractices.PostgreSQL" rel="nofollow noreferrer">Best Practices for Working with PostgreSQL</a>:</p>
  
  <pre><code>autovacuum  0
  checkpoint_completion_target  0.9
  checkpoint_timeout  3600
  maintenance_work_mem  {DBInstanceClassMemory/16384}
  max_wal_size  3145728
  synchronous_commit  off
  </code></pre>
  
  <p>Other than these, I also turned off <code>multi AZ</code> and back-up. SSL is enabled though, not sure this will change anything. However, after all the changes, still not much improvement. DataStage is uploading data in parallel already ~12 threads. Write IOPS is around 40/sec. Is this value normal? Is there anything else I can do to speed up the data transfer? </p>