As promised in my previous post on the PostgreSQL Oracle FDW, I've done some performance testing verses our old method of using DBI-Link to replicate tables from an Oracle 8i instance to PG 9.1.2. I've got good news on several fronts!
First being that there is a definite improvement on the replication speed. Here's some stats on our old process that copied an entire table of about 1.5million rows
So one of our clients is still stuck running an old Oracle 8i database. Please, no comments on how there's no more support and they should have moved off this long ago. We know. They know. Moving on...
Recent comments