Skip site navigation (1) Skip section navigation (2)

Re: slow update of index during insert/copy

From: Thomas Finneid <tfinneid(at)student(dot)matnat(dot)uio(dot)no>
To: Scott Carey <scott(at)richrelevance(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: slow update of index during insert/copy
Date: 2008-08-31 19:20:16
Message-ID: 48BAEEF0.8000406@ifi.uio.no (view raw or flat)
Thread:
Lists: pgsql-performance
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


In response to

pgsql-performance by date

Next:From: Craig RingerDate: 2008-09-01 01:49:33
Subject: Re: slow update of index during insert/copy
Previous:From: Scott CareyDate: 2008-08-31 18:38:15
Subject: Re: slow update of index during insert/copy

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group