Re: multirow insert - Mailing list pgsql-general

From Dimitri Fontaine
Subject Re: multirow insert
Date
Msg-id 200707181434.55235.dfontaine@hi-media.com
Whole thread Raw
In response to Re: multirow insert  (Tom Allison <tom@tacocat.net>)
List 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

Attachment

pgsql-general by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: [PERFORM] Parrallel query execution for UNION ALL Queries
Next
From: Ron Johnson
Date:
Subject: Re: createing indexes on large tables and int8