Ora2Pg -Data Export Major Speed Improvement
Paris, April 6th 2016
Last week I received a patch from Svetlana Shorina PostgresPro about regular expressions and conditions checks in the function responsible for data formatting. Following their Oracle source and PostgreSQL destination types, data needs to be transformed before being inserted into PostgreSQL.
I knew that this part would benefit from being optimized but I always thought that this was a waste of time because, in my experience, most of the migration time is taken by the BLOB/CLOB escaping and this is something that cannot really be optimized. This is why I’ve never done this optimisation work and I was wrong.
Well I decided to reconsider and to make some benchmarks on different kinds of tables and data. I was really surprised, here are the results.