Received: from maia.hub.org (maia-3.hub.org [200.46.204.243])
	by mail.postgresql.org (Postfix) with ESMTP id 9A9F86328CC
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Sun,  6 Jun 2010 10:15:29 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia,
	port 10024) with ESMTP id 03307-10
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Sun,  6 Jun 2010 13:15:21 +0000 (UTC)
Received: from news.hub.org (news.hub.org [200.46.204.72])
	by mail.postgresql.org (Postfix) with ESMTP id 0E5776327E1
	for <pgsql-performance@postgresql.org>;
	Sun,  6 Jun 2010 10:15:23 -0300 (ADT)
Received: from news.hub.org (news.hub.org [200.46.204.72])
	by news.hub.org (8.14.4/8.14.4) with ESMTP id o56DFFtu062031
	for <pgsql-performance@postgresql.org>;
	Sun, 6 Jun 2010 10:15:15 -0300 (ADT)
	(envelope-from news@news.hub.org)
Received: (from news@localhost)
	by news.hub.org (8.14.4/8.14.4/Submit) id o56C5eMU008889
	for pgsql-performance@postgresql.org;
	Sun, 6 Jun 2010 09:05:40 -0300 (ADT) (envelope-from news)
From: =?ISO-8859-1?Q?Torsten_Z=FChlsdorff?= <foo@meisterderspiele.de>
X-Newsgroups: pgsql.performance
Subject: Re: How to insert a bulk of data with unique-violations
  very fast
Date: Sun, 06 Jun 2010 14:05:44 +0200
Organization: A noiseless patient Spider
Lines: 9
Message-ID: <hug2uo$nu4$2@news.eternal-september.org>
References: <hu37gm$qrl$1@news.eternal-september.org>
	<AANLkTim0X5AyDz6K7uPdwCwoqNNSOjAUEsVJ9maS8aO0@mail.gmail.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
Injection-Date: Sun, 6 Jun 2010 12:05:44 +0000 (UTC)
Injection-Info: mx02.eternal-september.org;
	posting-host="MkmknxNEECXE1aUTxKBACA";
	logging-data="24516"; mail-complaints-to="abuse@eternal-september.org";
	posting-account="U2FsdGVkX194i0Bc1Y1/2Qmuubbu+L6n"
User-Agent: Thunderbird 2.0.0.21 (X11/20090330)
In-Reply-To: <AANLkTim0X5AyDz6K7uPdwCwoqNNSOjAUEsVJ9maS8aO0@mail.gmail.com>
Cancel-Lock: sha1:YfD3vEk8he0KnKhRFei6x9x4FgA=
To: pgsql-performance@postgresql.org
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.79 tagged_above=-10 required=5 tests=BAYES_50=0.8,
	T_RP_MATCHES_RCVD=-0.01
X-Spam-Level: 
X-Archive-Number: 201006/127
X-Sequence-Number: 38983

Cédric Villemain schrieb:

> I think you need to have a look at pgloader. It does COPY with error
> handling. very effective.

Thanks for this advice. I will have a look at it.

Greetings from Germany,
Torsten