The other query attempts given to me do not produce the desired results. Thanks for taking a look anyway.
Let me explain the problem set, and what I want to accomplish...
I have two tables in all cases. Each table pair consists of the following columns:
1. A primary key of one or more columns {with a unique index}
2. An Oid column {with a unique index}
3. A 64 bit CRC
For both tables, the primary key information will "mostly" match. I need to know which primary keys are found in the first table but not in the second. Also, which primary keys are found in the second table but not in the first.
One possibility would be to add a tag column and set it where the two tables agree on primary key. Unfortunately, we are likely to have many millions of rows (and only a few thousand disagreements) and so I would end up rewriting the entire table for both tables (less the tiny difference set) and hence that would be inefficient. My outer join also stinks up the place. (Several minutes for a million rows -- unacceptable).
Probably, I am going to have to write my own piece of custom software that manipulates the data outside of any database. The database query approach is just too slow.
