Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 8BEE3650202
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Mon,  1 Sep 2008 17:41:23 -0300 (ADT)
Received: from postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 10032-04-7
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Mon,  1 Sep 2008 17:41:08 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from wf-out-1314.google.com (wf-out-1314.google.com
 [209.85.200.169])
	by postgresql.org (Postfix) with ESMTP id D33C165027E
	for <pgsql-performance@postgresql.org>;
	Mon,  1 Sep 2008 17:40:52 -0300 (ADT)
Received: by wf-out-1314.google.com with SMTP id 25so2067156wfc.28
	for <pgsql-performance@postgresql.org>;
	Mon, 01 Sep 2008 13:40:50 -0700 (PDT)
Received: by 10.142.216.9 with SMTP id o9mr2251454wfg.0.1220301650722;
	Mon, 01 Sep 2008 13:40:50 -0700 (PDT)
Received: by 10.143.39.19 with HTTP; Mon, 1 Sep 2008 13:40:50 -0700 (PDT)
Message-ID: <a1ec7d000809011340u6b4ed9b1m3cffe0ccef2c0a2e@mail.gmail.com>
Date: Mon, 1 Sep 2008 13:40:50 -0700
From: "Scott Carey" <scott@richrelevance.com>
To: "Thomas Finneid" <tfinneid@student.matnat.uio.no>
Subject: Re: slow update of index during insert/copy
Cc: "Scott Marlowe" <scott.marlowe@gmail.com>,
	"Craig Ringer" <craig@postnewspapers.com.au>,
	pgsql-performance@postgresql.org
In-Reply-To: <48BC5178.60906@ifi.uio.no>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_59203_13595348.1220301650699"
References: <48BA9D65.2020001@ifi.uio.no>
	<48BB4A2D.9080404@postnewspapers.com.au> <48BBD22E.4090308@ifi.uio.no>
	<dcc563d10809011051s558f8a7bp5beb0dbe181721e4@mail.gmail.com>
	<a1ec7d000809011146x456b942eof33627c63f8a021a@mail.gmail.com>
	<48BC5178.60906@ifi.uio.no>
X-Google-Sender-Auth: eadc9dea5d05784c
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.001 tagged_above=0 required=5
	tests=HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200809/15
X-Sequence-Number: 31328

------=_Part_59203_13595348.1220301650699
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

>
>
>
>  On the performance impact of using COPY instead of INSERT :  out of
>> curiosity, were you comparing COPY against raw row-by-row inserts (slow) or
>> JDBC batch inserts (faster) or multi-row inserts: INSERT into X (a,b,c)
>> values (1,2,3) , (4,5,6) , (7,8,9 ) , (10,11,12)  .... ?
>>
>
> I tested row by row and jdbc batch, but I dont have the measured numbers
> any more. But I suppose I could recreate the test if, need be.
>
> regards
> thomas
>
>
> Don't re-create it, I was just curious.

------=_Part_59203_13595348.1220301650699
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

<div dir="ltr"><div class="gmail_quote"><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div class="Ih2E3d"><br>
<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
On the performance impact of using COPY instead of INSERT : &nbsp;out of curiosity, were you comparing COPY against raw row-by-row inserts (slow) or JDBC batch inserts (faster) or multi-row inserts: INSERT into X (a,b,c) values (1,2,3) , (4,5,6) , (7,8,9 ) , (10,11,12) &nbsp;.... ?<br>

</blockquote>
<br></div>
I tested row by row and jdbc batch, but I dont have the measured numbers any more. But I suppose I could recreate the test if, need be.<br>
<br>
regards<br><font color="#888888">
thomas<br>
<br>
<br>
</font></blockquote></div>Don&#39;t re-create it, I was just curious.<br></div>

------=_Part_59203_13595348.1220301650699--