Re: performance for high-volume log insertion - Mailing list pgsql-performance

Stephen Frost <sfrost@snowman.net> writes:
> * Glenn Maynard (glennfmaynard@gmail.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