Re: multirow insert

From: Tom Allison <tom(at)tacocat(dot)net>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: multirow insert
Date: 2007-07-14 00:59:39
Message-ID: EDE49CC8-4F2F-45F5-A15F-23FF4A313D0B@tacocat.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Glaesemann 2007-07-14 01:06:36 Re: pg_dump vs schemas
Previous Message Francisco Reyes 2007-07-14 00:10:33 pg_dump vs schemas