title: Slow bulk insert for table with many indexes
body: <p>I try to insert millions of records into a table that has more than 20 indexes.</p>
  
  <p>In the last run it took more than 4 hours per 100.000 rows, and the query was cancelled after 3½ days...</p>
  
  <p>Do you have any suggestions about how to speed this up.</p>
  
  <p>(I suspect the many indexes to be the cause. If you also think so, how can I automatically drop indexes before the operation, and then create the same indexes afterwards again?)</p>
  
  <p>Extra info:</p>
  
  <ul>
  <li>The space used by the indexes is about 4 times the space used by the data alone</li>
  <li>The inserts are wrapped in a transaction per 100.000 rows. </li>
  </ul>
  
  <hr>
  
  <p>Update on status:</p>
  
  <p>The accepted answer helped me make it much faster.</p>