Re: ETL optimization
От
Dennis Bjorklund
Тема
Re: ETL optimization
Дата
Msg-id
Pine.LNX.4.44.0506240624350.4501-100000@zigo.dhs.org
Ответ на
ETL optimization (Bricklen Anderson)
Список
Дерево обсуждения
ETL optimization Bricklen Anderson <BAnderson@PresiNET.com>
Re: ETL optimization Jacques Caron <jc@directinfos.com>
Re: ETL optimization Bricklen Anderson <BAnderson@PresiNET.com>
Re: ETL optimization Meetesh Karia <meetesh.karia@gmail.com>
Re: ETL optimization Bricklen Anderson <BAnderson@PresiNET.com>
Re: ETL optimization Dennis Bjorklund <db@zigo.dhs.org>
Re: ETL optimization Bricklen Anderson <BAnderson@PresiNET.com>
On Thu, 23 Jun 2005, Bricklen Anderson wrote: > iii. UNIQUE constraint on table "t1". This didn't seem to perform too > badly with fewer rows (preliminary tests), but as you'd expect, on error > the whole transaction would roll back. Is it possible to skip a row if > it causes an error, as opposed to aborting the transaction altogether? You don't need to roll back the whole transaction if you use savepoints or the exception features in pl/pgsql Take a look at this example: http://developer.postgresql.org/docs/postgres/plpgsql-control-structures.html#PLPGSQL-UPSERT-EXAMPLE -- /Dennis Björklund
В списке pgsql-performance по дате отправления
