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.