On Wed, Apr 22, 2009 at 4:07 PM, <david@xxxxxxx> 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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
