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
I've finally gotten Git support added into pg_extractor. This works pretty much the same as the SVN option did already. One important difference is that there are two options for committing
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...
For my debut blog post, I'll be explaining a tool, pg_extractor, that I began working on at my current job. I'd like to first give a big thank you to depesz and the DBA team at OmniTI for their help in making this tool.
{...}
Working on this tool has shown many shortcomings with the built in pg_dump/restore. One of my hopes with this project is to show what improvements can be made and possibly built in sometime in the future.
{...}
Probably best to move on to some examples instead of continuing this wall of text...
Recent comments