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: Greenplum/Postgres


Regards,
Srikanth k Potluri
+63 9177444783(philippines)