Re: Good way to insert/update when you're not sure of duplicates? - Mailing list pgsql-general

From Dennis Gearon
Subject Re: Good way to insert/update when you're not sure of duplicates?
Date
Msg-id 3F7458C4.8090309@fireserve.net
Whole thread Raw
In response to Re: Good way to insert/update when you're not sure of duplicates?  (Shridhar Daithankar <shridhar_daithankar@persistent.co.in>)
Responses Re: Good way to insert/update when you're not sure of duplicates?
List pgsql-general
Shridhar Daithankar wrote:

>
> In addition to that, you can try inserting from multiple backends
> simaltenously to speed up the whole process.
>
> And I don't like the modes idea OP gave. I would rather follow
> insert->if-error-update mode in a transaction for each record. And
> fork over say 20/40 parallel backends to achieve good speed.
>
I didn't think mulitple backends worked.


pgsql-general by date:

Previous
From: Didier Bretin
Date:
Subject: Escape sequence for unicode characters
Next
From: Shridhar Daithankar
Date:
Subject: Re: Good way to insert/update when you're not sure of duplicates?