Inserting/Updating

• Constant-time operation
   
• Speed increases:
   
• Use application to apply business logic first
   
• Have application create easy-to-load format
   
• Turn fsync off
   
• Use COPY, not INSERT
  

  INSERT mytable (col1, col2) FROM stdin;
  data1<tab>data2
  \.
  

  
   
• Drop triggers and rules. (deferred and statement-level triggers)
   
• If you do use triggers, check memory
   
• Drop indexes
   
• No autocommit (commit in batches)
   
• Load in smaller chunks
   
• Boost the WAL settings
   
• Minimal logging
   
• Put logs on a different disk
 
 
• UPDATES have similar guidelines
   
• UPDATE = delete + insert in MVCC, so VACUUM!

Previous: Nulls         [Table of Contents]         Next: Table Stats