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
Ответ на
Список
Дерево обсуждения
Problem with aborting entire transactions on error Zbigniew <zbigniew2011@gmail.com>
Re: Problem with aborting entire transactions on error Merlin Moncure <mmoncure@gmail.com>
Re: Problem with aborting entire transactions on error Scott Marlowe <scott.marlowe@gmail.com>
Re: Problem with aborting entire transactions on error Zbigniew <zbigniew2011@gmail.com>
Re: Problem with aborting entire transactions on error Andrew Sullivan <ajs@crankycanuck.ca>
Re: Problem with aborting entire transactions on error Scott Marlowe <scott.marlowe@gmail.com>
Re: Problem with aborting entire transactions on error Chris Angelico <rosuav@gmail.com>
Re: Problem with aborting entire transactions on error Zbigniew <zbigniew2011@gmail.com>
Re: Problem with aborting entire transactions on error Chris Angelico <rosuav@gmail.com>
Re: Problem with aborting entire transactions on error Zbigniew <zbigniew2011@gmail.com>
Re: Problem with aborting entire transactions on error Craig Ringer <craig@2ndQuadrant.com>
Re: Problem with aborting entire transactions on error Abel Abraham Camarillo Ojeda <acamari@the00z.org>
Re: Problem with aborting entire transactions on error Abel Abraham Camarillo Ojeda <acamari@the00z.org>
Re: Problem with aborting entire transactions on error Zbigniew <zbigniew2011@gmail.com>
Re: Problem with aborting entire transactions on error David Johnston <polobo@yahoo.com>
Re: Problem with aborting entire transactions on error Abel Abraham Camarillo Ojeda <acamari@the00z.org>
Re: Problem with aborting entire transactions on error Zbigniew <zbigniew2011@gmail.com>
Re: Problem with aborting entire transactions on error David Johnston <polobo@yahoo.com>
Re: Problem with aborting entire transactions on error Thomas Kellerer <spam_eater@gmx.net>
Re: Problem with aborting entire transactions on error Виктор Егоров <vyegorov@gmail.com>
Re: Problem with aborting entire transactions on error Ondrej Ivanič <ondrej.ivanic@gmail.com>
On Dec 11, 2012, at 6:48, Zbigniew  wrote:

> 2012/12/11, Abel Abraham Camarillo Ojeda :
> 
>> 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 the delta gain you can run the second transformation query.  Your desired feature probably wouldn't work with copy anyway and high-performance bulk loading should use that API.

David J.


В списке pgsql-general по дате отправления
От: Merlin Moncure
Дата:
Сообщение: Re: Looking for cooperators
От: Merlin Moncure
Дата:
FAQ