Hi team,

I am using COPY to load data in my tables from CSV file.
File size : 16 gb
time taken to drop index + truncate data + load data + apply index is : 1.5 hrs.

how can i reduce the time ?

OS : SOLARIS 10
Machine : THUMPER (x4500, SUN )
Datatbase : greenplum (based on postgresql)
postgres version : 8.4
greenplum version : 3.0.0.2

Your suggestion will be of great help to me .


Thanks & Regards,
Srikanth k Potluri
+63 9177444783(philippines)