* Emi Lu (em...@encs.concordia.ca) wrote:
> >*
> >>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, 100
*
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 co
* Emi Lu (em...@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
Emi Lu-2 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)
>
> Thanks a lot!
> Em
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)
Thanks a lot!
Emi
--
Sent via pgsql-performance
On 2014-08-21 14:02:26 -0700, Josh Berkus wrote:
> On 08/20/2014 07:40 PM, Bruce Momjian wrote:
> > Not sure how you can make such a blanket statement when so many people
> > have tested and shown the benefits of hyper-threading.
>
> Actually, I don't know that anyone has posted the benefits of
On 08/22/2014 01:37 AM, Scott Marlowe wrote:
I thought they were fixed in 3.8.something? We're running 3.8 on our
production servers but IO is not an issue for us.
Yeah. 3.8 fixed a ton of issues that were plaguing us. There were still
a couple patches I wanted that didn't get in until 3.11+,
