copy vs. insert w/ no autocommit

From: Matthew Kennedy <mkennedy(at)opushealthcare(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: copy vs. insert w/ no autocommit
Date: 2001-12-18 21:11:37
Message-ID: 1008709897.7512.26.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message SHELTON,MICHAEL (Non-HP-Boise,ex1) 2001-12-18 21:22:10 Re: Way to use count() and LIMIT?
Previous Message SHELTON,MICHAEL (Non-HP-Boise,ex1) 2001-12-18 20:18:13 Re: Way to use count() and LIMIT?