On Wed, Apr 22, 2009 at 4:07 PM, <david(at)lang(dot)hm> wrote:
> are these done as seperate round trips?
>
> i.e.
> begin <send>
> insert <send>
> insert <send>
> ..
> end <send>
>
> or as one round trip?
All tests were done by constructing a file and using "time psql -f ...".
>> 40 inserts, 100 rows/insert: 0.18s
>> one 40000-value insert: 0.16s
>> 40 prepared inserts, 100 rows/insert: 0.15s
>
> are one of these missing a 0?
Sorry, 400 * 100. All cases inserted 40000 rows, and I deleted all
rows between tests (but did not recreate the table).
--
Glenn Maynard