Stephen Frost <[email protected]> writes:
> * Glenn Maynard ([email protected]) 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 ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
