Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 15A1165017B
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Sun, 31 Aug 2008 16:20:19 -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 96715-06 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Sun, 31 Aug 2008 16:20:11 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from mail-out1.uio.no (mail-out1.uio.no [129.240.10.57])
	by postgresql.org (Postfix) with ESMTP id 0D280650173
	for <pgsql-performance@postgresql.org>;
	Sun, 31 Aug 2008 16:20:13 -0300 (ADT)
Received: from mail-mx3.uio.no ([129.240.10.44])
	by mail-out1.uio.no with esmtp (Exim 4.69)
	(envelope-from <tfinneid@ifi.uio.no>)
	id 1KZsT6-0005gO-33; Sun, 31 Aug 2008 21:20:12 +0200
Received: from 165.84-49-232.nextgentel.com ([84.49.232.165] helo=[10.0.0.10])
	by mail-mx3.uio.no with esmtpsa (TLSv1:AES256-SHA:256)
	user tfinneid (Exim 4.67) (envelope-from <tfinneid@ifi.uio.no>)
	id 1KZsT5-0001vM-RO; Sun, 31 Aug 2008 21:20:12 +0200
Message-ID: <48BAEEF0.8000406@ifi.uio.no>
Date: Sun, 31 Aug 2008 21:20:16 +0200
From: Thomas Finneid <tfinneid@student.matnat.uio.no>
User-Agent: Thunderbird 2.0.0.16 (X11/20080724)
MIME-Version: 1.0
To: Scott Carey <scott@richrelevance.com>
CC: pgsql-performance@postgresql.org
Subject: Re: slow update of index during insert/copy
References: <48BA9D65.2020001@ifi.uio.no>
	<a1ec7d000808311138k76d5291bh64806a1cdef3b0e6@mail.gmail.com>
In-Reply-To: <a1ec7d000808311138k76d5291bh64806a1cdef3b0e6@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-UiO-SPF-Received: 
X-UiO-Spam-info: not spam, SpamAssassin (score=-4.5, required=5.0,
	autolearn=disabled, TVD_RCVD_IP=0.502, UIO_MAIL_IS_INTERNAL=-5,
	uiobl=NO, uiouri=NO)
X-UiO-Scanned: E7CE40A2C2C6E8DE16AEB24FA39388AD2C1F1364
X-UiO-SPAM-Test: remote_host: 84.49.232.165 spam_score: -44 maxlevel 200
	minaction 2 bait 0 mail/h: 1 total 53 max/h 6 blacklist 0
	greylist 0 ratelimit 0
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=1.407 tagged_above=0 required=5
	tests=NO_DNS_FOR_FROM=1.407
X-Spam-Level: *
X-Archive-Number: 200808/431
X-Sequence-Number: 31312


Scott Carey wrote:
> You may want to investigate pg_bulkload.
> 
> http://pgbulkload.projects.postgresql.org/
> 
> One major enhancement over COPY is that it does an index merge, rather 
> than modify the index one row at a time. 

This is a command line tool, right? I need a jdbc driver tool, is that 
possible?

regards

thomas