Le mardi 4 septembre 2007, Tom Lane a écrit :
> =?utf-8?q?C=C3=A9dric_Villemain?= <[EMAIL PROTECTED]> writes:
> > In order to make some trivial test, I have start patching pg_dump to
> > get=20 insert using multi-rows (like --inserts option).
> Why?  COPY is faster and won't have issues for very large numbers of
> rows.

Well, I can only make a new ask.
Why is there the --inserts and --attribute-inserts options ?

As copy is very fast, I find fast (in front of simple insert) the multi-rows 
inserts. For a very small test I had 20, 30 and 440 seconds to restore 
respectively copy, mutiinserts and inserts. 

>                       regards, tom lane
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>                http://www.postgresql.org/docs/faq

Cédric Villemain
Administrateur de Base de Données
Cel: +33 (0)6 74 15 56 53
http://dalibo.com - http://dalibo.org

Attachment: signature.asc
Description: This is a digitally signed message part.

Reply via email to