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

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: autocommit (true/false) for more than 1 million records
Дата
Msg-id CAMkU=1xWQdCs0nbZSXrkdK4Y7moLKWV8X60MSdDSw-oR27L7yw@mail.gmail.com
обсуждение исходный текст
Ответ на autocommit (true/false) for more than 1 million records  (Emi Lu <emilu@encs.concordia.ca>)
Ответы Re: autocommit (true/false) for more than 1 million records
Список pgsql-performance
Дерево обсуждения
On Fri, Aug 22, 2014 at 1:49 PM, Emi Lu <emilu@encs.concordia.ca> wrote:
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)

In general it is better to use COPY (however JDBC for 8.3. exposes that), as that is designed specifically for bulk loading.

Then it doesn't matter whether autocommit is on or off, because the COPY is a single statement.

Cheers,

Jeff

В списке pgsql-performance по дате отправления: