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

From Matthew Wakeling
Subject Re: slow update of index during insert/copy
Date
Msg-id alpine.DEB.1.10.0809021324530.4454@aragorn.flymine.org
Whole thread Raw
In response to Re: slow update of index during insert/copy  ("Scott Carey" <scott@richrelevance.com>)
List pgsql-performance
On Mon, 1 Sep 2008, Scott Carey wrote:
> Thanks for the info on the patch to support it -- however the versions
> posted there are rather old...

Over here, we're using an extremely old patched version of the JDBC
driver. That's the patch I sent to some mailing list a couple of years
ago. It works very well, but I would be very eager to see the COPY support
make it to the mainstream driver with a consistent interface.

> On the performance impact of using COPY instead of INSERT.

Over here, we use the binary form of COPY, and it is *really* fast. It's
quite easy to saturate the discs.

Matthew

--
Contrary to popular belief, Unix is user friendly. It just happens to be
very selective about who its friends are.                 -- Kyle Hearn

pgsql-performance by date:

Previous
From: "David West"
Date:
Subject: Re: limit clause breaks query planner?
Next
From: Guillaume Cottenceau
Date:
Subject: Re: limit clause breaks query planner?