Postgres Pro
Downloads
Home   >   mailing lists

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
Re: autocommit (true/false) for more than 1 million records
Re: autocommit (true/false) for more than 1 million records
List pgsql-performance
Tree view 
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