| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | Stephen Froehlich <s(dot)froehlich(at)cablelabs(dot)com> |
| Cc: | Andreas Kretschmer <andreas(at)a-kretschmer(dot)de>, "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Re: COPY from temp table to main table insted of INSERT INTO |
| Date: | 2017-07-11 19:06:17 |
| Message-ID: | CAKFQuwba6Dy-qc4iaruUbyGsxua1wYad0sQ1ELmWtyUJpBPT2g@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
On Tuesday, July 11, 2017, Stephen Froehlich <s(dot)froehlich(at)cablelabs(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jonathan Moules | 2017-07-12 10:25:06 | Setting a DEFAULT when NULL is inserted |
| Previous Message | Stephen Froehlich | 2017-07-11 18:40:35 | Re: COPY from temp table to main table insted of INSERT INTO |