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