Re: performance for high-volume log insertion

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: performance for high-volume log insertion
Date: 2009-04-22 20:49:09
Message-ID: 11633.1240433349@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message James Mansion 2009-04-22 20:53:03 Re: performance for high-volume log insertion
Previous Message david 2009-04-22 20:07:34 Re: performance for high-volume log insertion