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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-performance by date

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