ginal --
From: "Steven Schlansker";;
Date: Thu, Sep 26, 2013 01:50 AM
To: "Merlin Moncure";
Cc: "François Beausolei"; "Forums
postgresql";
Subject: Re: [GENERAL] Deduplication and transaction isolation level
On Sep 25, 2013, at 6:04 AM, Merlin
On Wed, Sep 25, 2013 at 12:50 PM, Steven Schlansker wrote:
>
> On Sep 25, 2013, at 6:04 AM, Merlin Moncure wrote:
>
>> On Tue, Sep 24, 2013 at 10:19 PM, François Beausoleil
>> wrote:
>>> Hi all!
>>>
>>> I import many, many rows of data into a table, from three or more
>>> computers, 4 times per
On Sep 25, 2013, at 6:04 AM, Merlin Moncure wrote:
> On Tue, Sep 24, 2013 at 10:19 PM, François Beausoleil
> wrote:
>> Hi all!
>>
>> I import many, many rows of data into a table, from three or more computers,
>> 4 times per hour. I have a primary key, and the query I use to import the
>> da
Le 2013-09-25 à 09:04, Merlin Moncure a écrit :
> On Tue, Sep 24, 2013 at 10:19 PM, François Beausoleil
> wrote:
>> Hi all!
>>
>> I import many, many rows of data into a table, from three or more computers,
>> 4 times per hour. I have a primary key, and the query I use to import the
>> data i
On Tue, Sep 24, 2013 at 10:19 PM, François Beausoleil
wrote:
> Hi all!
>
> I import many, many rows of data into a table, from three or more computers,
> 4 times per hour. I have a primary key, and the query I use to import the
> data is supposed to dedup before inserting, but I still get primar
Hi all!
I import many, many rows of data into a table, from three or more computers, 4
times per hour. I have a primary key, and the query I use to import the data is
supposed to dedup before inserting, but I still get primary key violations.
The import process is:
* Load CSV data into temp ta