autocommit (true/false) for more than 1 million records - Mailing list pgsql-performance

From Emi Lu
Subject autocommit (true/false) for more than 1 million records
Date
Msg-id 53F7ACF4.1010604@encs.concordia.ca
Whole thread Raw
Responses Re: autocommit (true/false) for more than 1 million records  (David G Johnston <david.g.johnston@gmail.com>)
Re: autocommit (true/false) for more than 1 million records  (Stephen Frost <sfrost@snowman.net>)
Re: autocommit (true/false) for more than 1 million records  (Jeff Janes <jeff.janes@gmail.com>)
List 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




pgsql-performance by date:

Previous
From: Andres Freund
Date:
Subject: Re: Turn off Hyperthreading! WAS: 60 core performance with 9.3
Next
From: David G Johnston
Date:
Subject: Re: autocommit (true/false) for more than 1 million records