On Dec 11, 2012, at 6:48, Zbigniew <[email protected]> wrote: > 2012/12/11, Abel Abraham Camarillo Ojeda <[email protected]>: > >> 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 ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
