Search Postgresql Archives

Re: Problem with aborting entire transactions on error

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Dec 11, 2012, at 6:48, Zbigniew <zbigniew2011@xxxxxxxxx> wrote:

> 2012/12/11, Abel Abraham Camarillo Ojeda <acamari@xxxxxxxxxx>:
> 
>> 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.



-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux