Postgres Pro
Downloads
Home   >   mailing lists

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

From Jeff Janes
Subject Re: autocommit (true/false) for more than 1 million records
Date
Msg-id CAMkU=1xWQdCs0nbZSXrkdK4Y7moLKWV8X60MSdDSw-oR27L7yw@mail.gmail.com
Whole thread Raw
In response to autocommit (true/false) for more than 1 million records  (Emi Lu <emilu@encs.concordia.ca>)
Responses Re: autocommit (true/false) for more than 1 million records  (Alex Goncharov <alex.goncharov.usa@gmail.com>)
List pgsql-performance
Tree view
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 by date:

Previous
From: Felipe Santos
Date:
Subject: Re: autocommit (true/false) for more than 1 million records
Next
From: Jeison Bedoya Delgado
Date:
Subject: tuning postgresql 9.3.5 and multiple cores