Re: slow speeds after 2 million rows inserted

From: Guy Rouillier <guyr-ml1(at)burntmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: slow speeds after 2 million rows inserted
Date: 2006-12-30 00:34:17
Message-ID: 4595B409.2040301@burntmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Michael Fuhr 2006-12-30 02:02:29 Re: psql script error handling
Previous Message Ben 2006-12-30 00:31:21 Re: Geographical redundancy