autocommit (true/false) for more than 1 million records

From: Emi Lu <emilu(at)encs(dot)concordia(dot)ca>
To: pgsql-performance(at)postgresql(dot)org
Subject: autocommit (true/false) for more than 1 million records
Date: 2014-08-22 20:49:56
Message-ID: 53F7ACF4.1010604@encs.concordia.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hello,

Trying to insert into one table with 1 million records through java JDBC
into psql8.3. May I know (1) or (2) is better please?

(1) set autocommit(true)
(2) set autocommit(false)
commit every n records (e.g., 100, 500, 1000, etc)

Thanks a lot!
Emi

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message David G Johnston 2014-08-22 20:58:34 Re: autocommit (true/false) for more than 1 million records
Previous Message Andres Freund 2014-08-22 14:02:23 Re: Turn off Hyperthreading! WAS: 60 core performance with 9.3