Re: Good way to insert/update when you're not sure of duplicates?

Поиск
Список
Период
Сортировка
От Dennis Gearon
Тема Re: Good way to insert/update when you're not sure of duplicates?
Дата
Msg-id 3F7458C4.8090309@fireserve.net
обсуждение исходный текст
Ответ на Re: Good way to insert/update when you're not sure of duplicates?  (Shridhar Daithankar <shridhar_daithankar@persistent.co.in>)
Ответы Re: Good way to insert/update when you're not sure of duplicates?  (Shridhar Daithankar <shridhar_daithankar@persistent.co.in>)
Список 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 по дате отправления:

Предыдущее
От: Didier Bretin
Дата:
Сообщение: Escape sequence for unicode characters
Следующее
От: Shridhar Daithankar
Дата:
Сообщение: Re: Good way to insert/update when you're not sure of duplicates?