Search Postgresql Archives

Re: multirow insert

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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: signature.asc
Description: This is a digitally signed message part.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux