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 по дате отправления