Re: multirow insert - Mailing list pgsql-general

From Tom Allison
Subject Re: multirow insert
Date
Msg-id EDE49CC8-4F2F-45F5-A15F-23FF4A313D0B@tacocat.net
Whole thread Raw
In response to Re: multirow insert  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
Responses Re: multirow insert  (Dimitri Fontaine <dfontaine@hi-media.com>)
List pgsql-general
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.

I have a little program that was a 100x improvement in performance by
changing my SQL to use INSERT INTO ... VALUES


pgsql-general by date:

Previous
From: Francisco Reyes
Date:
Subject: pg_dump vs schemas
Next
From: Michael Glaesemann
Date:
Subject: Re: pg_dump vs schemas