Re: How to insert a bulk of data with unique-violations very fast - Mailing list pgsql-performance

From Scott Marlowe
Subject Re: How to insert a bulk of data with unique-violations very fast
Date
Msg-id AANLkTim36aTPinMgAQ9bUcf0AD4S1YKRrXfApHERRd7U@mail.gmail.com
Whole thread Raw
In response to Re: How to insert a bulk of data with unique-violations very fast  (Torsten Zühlsdorff <foo@meisterderspiele.de>)
Responses Re: How to insert a bulk of data with unique-violations very fast
List pgsql-performance
On Sun, Jun 6, 2010 at 6:02 AM, Torsten Zühlsdorff
<foo@meisterderspiele.de> wrote:
> Scott Marlowe schrieb:
> Thank you very much for your example. Now i've got it :)
>
> I've test your example on a small set of my rows. While testing i've
> stumpled over a difference in sql-formulation. Using except seems to be a
> little slower than the more complex where not in (subquery) group by. Here
> is my example:

Yeah, to get a good idea you need a more realistic example.  Build
some tables with millions of rows using generate_series() and then
test against those.

pgsql-performance by date:

Previous
From: Torsten Zühlsdorff
Date:
Subject: Re: How to insert a bulk of data with unique-violations very fast
Next
From: "Pierre C"
Date:
Subject: Re: How to insert a bulk of data with unique-violations very fast