Postgres Pro
Downloads
Home   >   mailing lists

Re: slow update of index during insert/copy - Mailing list pgsql-performance

From Thomas Finneid
Subject Re: slow update of index during insert/copy
Date
Msg-id 48BAEEF0.8000406@ifi.uio.no
Whole thread Raw
In response to Re: slow update of index during insert/copy  ("Scott Carey" <scott@richrelevance.com>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: "Scott Carey"
Date:
Subject: Re: slow update of index during insert/copy
Next
From: Craig Ringer
Date:
Subject: Re: slow update of index during insert/copy