*
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
--
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
