Query on database migration
--------------------------------
We are thinking of migrating one application from Oracle 10g to
Postgre environment. We are using Oracle 10g Merge functionality to comprae
and filter out the records into two groups. The master database
size is having about 11 million records and comparision table which
is to be compared can have upto 130000 records. This is a
continous process and daily some 1200 such comparisns are done.
Could you guide me if their is any equivalent functionality to
that of Oracle Merge function available in any of the postgre version or any best way to do this task to get maximum throughputand performance.
Your reply would be highly appreciated.
with regards,
I.P.S. Sethi
Technical Director,
National Informatics Centre,
Department of Information Technology,
New Delhi.
