title: How to speed up insertion performance in PostgreSQL
body: <p>I am testing Postgres insertion performance. I have a table with one column with number as its data type. There is an index on it as well. I filled the database up using this query:</p>
  
  <pre><code>insert into aNumber (id) values (564),(43536),(34560) ...
  </code></pre>
  
  <p>I inserted 4 million rows very quickly 10,000 at a time with the query above. After the database reached 6 million rows performance drastically declined to 1 Million rows every 15 min. Is there any trick to increase insertion performance? I need optimal insertion performance on this project.</p>
  
  <p>Using Windows 7 Pro on a machine with 5 GB RAM.</p>