copy vs. insert w/ no autocommit

Поиск
Список
Период
Сортировка
Искать
От
Matthew Kennedy
Тема
copy vs. insert w/ no autocommit
Дата
Msg-id
1008709897.7512.26.camel@localhost.localdomain
Список
Дерево обсуждения
copy vs. insert w/ no autocommit Matthew Kennedy <mkennedy@opushealthcare.com>
Re: copy vs. insert w/ no autocommit Francisco Reyes <lists@natserv.com>
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 по дате отправления
От: SHELTON,MICHAEL (Non-HP-Boise,ex1)
Дата:
От: Joe Koenig
Дата:
FAQ