Re: pg_dump and insert multi-rows option

Le mardi 4 septembre 2007, Tom Lane a écrit :
> =?utf-8?q?C=C3=A9dric_Villemain?= <cedric(dot)villemain(at)dalibo(dot)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