Re: Problem with aborting entire transactions on error

Поиск
Список
Период
Сортировка
От David Johnston
Тема Re: Problem with aborting entire transactions on error
Дата
Msg-id B7AF2D92-5916-4B4F-A14A-DE2E2FD6FA82@yahoo.com
обсуждение исходный текст
Ответ на Re: Problem with aborting entire transactions on error  (Zbigniew <zbigniew2011@gmail.com>)
Список pgsql-general
On Dec 11, 2012, at 6:48, Zbigniew <zbigniew2011@gmail.com> wrote:

> 2012/12/11, Abel Abraham Camarillo Ojeda <acamari@the00z.org>:
>
>> Obviously, it's not fast...
>
> Well, the problem was exactly speed-related. If not this - I could
> simply dispose of the transaction...
> --
> regards,
> Zbigniew
>
>

It seems like if you switched to the COPY API and a staging table your initial performance would be maximized and from
thedelta gain you can run the second transformation query.  Your desired feature probably wouldn't work with copy
anywayand high-performance bulk loading should use that API. 

David J.



В списке pgsql-general по дате отправления:

Предыдущее
От: Merlin Moncure
Дата:
Сообщение: Re: Looking for cooperators
Следующее
От: Merlin Moncure
Дата:
Сообщение: Re: Problem with aborting entire transactions on error