Re: [PERFORM] Best practice to load a huge table from ORACLE to PG

But do we link oracle trigger to postgres trigger ? i mean : oracle trigger will take a note of what has been changed . but then how do we pass those changes to postgres trigger ? can u suggest any logic or algorithm ? Regards, Srikanth k Potluri +63 9177444783(philippines) On Sat 26/04

[PERFORM] bulk data loading

Hi all, I need to do a bulk data loading around 704GB (log file size) at present  in 8 hrs (1 am - 9am). The data file size may increase 3 to 5 times in future. Using COPY it takes 96 hrs to finish the task. What is the best way to do it ? HARDWARE: SUN THUMPER/ RAID10 OS : SOLARIS 10. DB: Gree