Postgres Pro
Downloads
Home   >   mailing lists

Re: [NOVICE] COPY from temp table to main table insted of INSERT INTO - Mailing list pgsql-novice

From David G. Johnston
Subject Re: [NOVICE] COPY from temp table to main table insted of INSERT INTO
Date
Msg-id CAKFQuwba6Dy-qc4iaruUbyGsxua1wYad0sQ1ELmWtyUJpBPT2g@mail.gmail.com
Whole thread Raw
In response to Re: [NOVICE] COPY from temp table to main table insted of INSERT INTO  (Stephen Froehlich <s.froehlich@cablelabs.com>)
List pgsql-novice
Tree view
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 by date:

Previous
From: Stephen Froehlich
Date:
Subject: Re: [NOVICE] COPY from temp table to main table insted of INSERT INTO
Next
From: Jonathan Moules
Date:
Subject: [NOVICE] Setting a DEFAULT when NULL is inserted