Re: slow speeds after 2 million rows inserted - Mailing list pgsql-general

From Guy Rouillier
Subject Re: slow speeds after 2 million rows inserted
Date
Msg-id 4595B409.2040301@burntmail.com
Whole thread Raw
In response to Re: slow speeds after 2 million rows inserted  (Frank Finner <postgresql@finner.de>)
List pgsql-general
Frank Finner wrote:
> In Java, assuming you have a Connection c, you simply say
> "c.commit();" after doing some action on the database. After every
> commit, the transaction will be executed and closed and a new one
> opened, which runs until the next commit.

Assuming, of course, you started with c.setAutoCommit(false);

--
Guy Rouillier

pgsql-general by date:

Previous
From: Ben
Date:
Subject: Re: Geographical redundancy
Next
From: Michael Fuhr
Date:
Subject: Re: psql script error handling