| From: | Dimitri Fontaine <dfontaine(at)hi-media(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Cc: | Tom Allison <tom(at)tacocat(dot)net> |
| Subject: | Re: multirow insert |
| Date: | 2007-07-18 12:34:52 |
| Message-ID: | 200707181434.55235.dfontaine@hi-media.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Le samedi 14 juillet 2007, Tom Allison a écrit :
> On Jul 13, 2007, at 2:11 PM, A. Kretschmer wrote:
> > am Fri, dem 13.07.2007, um 18:50:26 +0200 mailte Zlatko Mati?
> >
> > folgendes:
> >> When using multirow INSERT INTO...VALUES command, are all rows
> >> inserted in a
> >> batch, or row by row?
> >
> > Within one transaction, yes.
>
> Trust me... It's MUCH faster then trying to do each insert.
Or read this article about the case:
http://www.depesz.com/index.php/2007/07/05/how-to-insert-data-to-database-as-fast-as-possible/
Regards,
--
dim
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nico Sabbi | 2007-07-18 13:10:30 | REQUEST: option to auto-generate new sequences with CREATE TABLE (LIKE) |
| Previous Message | Frank van Vugt | 2007-07-18 11:48:52 | it works, but is it legal to separate schema/table/field references using spaces |