Re: slow speeds after 2 million rows inserted

From: James Neff <jneff(at)tethyshealth(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: slow speeds after 2 million rows inserted
Date: 2006-12-29 19:36:44
Message-ID: 45956E4C.4050005@tethyshealth.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.
>
> Regards, Frank.
>
>

That did it, thank you!

--James

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Nikola Milutinovic 2006-12-29 19:50:12 Re: slow speeds after 2 million rows inserted
Previous Message Frank Finner 2006-12-29 19:28:25 Re: slow speeds after 2 million rows inserted