Stephen Frost <sfrost(at)snowman(dot)net> writes:
> * Glenn Maynard (glennfmaynard(at)gmail(dot)com) 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