copy vs. insert w/ no autocommit - Mailing list pgsql-general

From Matthew Kennedy
Subject copy vs. insert w/ no autocommit
Date
Msg-id 1008709897.7512.26.camel@localhost.localdomain
Whole thread Raw
Responses Re: copy vs. insert w/ no autocommit
List pgsql-general
I realize a COPY statement is much faster than individual INSERT
statements. But how does COPY compare to individual INSERTS within a
BEGIN/END or with setAutoCommit(false)? If there's a difference, are we
talking orders-of-magnitude in difference? (I am using JDBC and my
design might be affected depending on whether COPY is faster than a
prepared INSERT w/ auto-commit off.)

Matt




pgsql-general by date:

Previous
From: "SHELTON,MICHAEL (Non-HP-Boise,ex1)"
Date:
Subject: Re: Way to use count() and LIMIT?
Next
From: Joe Koenig
Date:
Subject: Re: Way to use count() and LIMIT?