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

> *
>> 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)
> It depends on what you need.
>
> Data will be available to concurrent processes earlier with (1), while
> (2) will go faster.
No need to worry about the lock/loosing records because after data
loading will do a check. For now, I'd like the fastest way. Would you
suggest commit every 1000 or 3000 records?

Thanks a lot!
Emi