Re: [NOVICE] COPY from temp table to main table insted of INSERT INTO

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: [NOVICE] COPY from temp table to main table insted of INSERT INTO
Дата
Msg-id CAKFQuwba6Dy-qc4iaruUbyGsxua1wYad0sQ1ELmWtyUJpBPT2g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [NOVICE] COPY from temp table to main table insted of INSERT INTO  (Stephen Froehlich <s.froehlich@cablelabs.com>)
Список pgsql-novice
Дерево обсуждения
On Tuesday, July 11, 2017, Stephen Froehlich <s.froehlich@cablelabs.com> wrote:
Will it be any faster if I put the INSERT INTO inside of a BEGIN INSERT INTO ... COMMIT?

Assuming your original insert statement is executed in auto-commit mode, and you only have the one statement, then adding an explicit begin commit will not change anything since there is already an implicit transaction that gets run.

Note the assumptions.  It would help if you can give more actual code/details so those helping don't have to make as many.

David J.

В списке pgsql-novice по дате отправления:

Предыдущее
От: Stephen Froehlich
Дата:
Сообщение: Re: [NOVICE] COPY from temp table to main table insted of INSERT INTO
Следующее
От: Jonathan Moules
Дата:
Сообщение: [NOVICE] Setting a DEFAULT when NULL is inserted