Message-ID: <53F7B1E5.6030507@encs.concordia.ca>
Date: Fri, 22 Aug 2014 17:11:01 -0400
From: Emi Lu <emilu@encs.concordia.ca>
Reply-To: emilu@encs.concordia.ca
User-Agent: Mozilla/5.0 (X11; Linux i686 on x86_64;
 rv:24.0) Gecko/20100101 Thunderbird/24.7.0
MIME-Version: 1.0
To: pgsql-performance@postgresql.org
CC: sfrost@snowman.net, david.g.johnston@gmail.com
Subject: Re: autocommit (true/false) for more than 1 million records
References: <53F7ACF4.1010604@encs.concordia.ca>
 <20140822210018.GZ16422@tamriel.snowman.net>
In-Reply-To: <20140822210018.GZ16422@tamriel.snowman.net>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

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