Le mardi 4 septembre 2007, Tom Lane a écrit :
> Cédric Villemain <cedric.villemain@dalibo.com> 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