Stephen Frost <sfrost@xxxxxxxxxxx> writes: > * Glenn Maynard (glennfmaynard@xxxxxxxxx) wrote: >> separate inserts, no transaction: 21.21s >> separate inserts, same transaction: 1.89s >> 40 inserts, 100 rows/insert: 0.18s >> one 40000-value insert: 0.16s >> 40 prepared inserts, 100 rows/insert: 0.15s >> COPY (text): 0.10s >> COPY (binary): 0.10s > What about 40000 individual prepared inserts? Just curious about it. Also, just to be clear: were the "40 insert" cases 40 separate transactions or one transaction? I think the latter was meant but it's not 100% clear. regards, tom lane -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
