<HTML>
Hi team,<br>
<br>
I am using COPY to load data in my tables from CSV file.<br>
File size : 16 gb<br>
time taken to drop index + truncate data + load data + apply index is : 1.5 hrs.<br>
<br>
how can i reduce the time ?<br>
<br>
OS : SOLARIS 10<br>
Machine : THUMPER (x4500, SUN )<br>
Datatbase : greenplum (based on postgresql) <br>
postgres version : 8.4<br>
greenplum version : 3.0.0.2<br>
<br>
Your suggestion will be of great help to me .<br>
<br>
<br>
Thanks & Regards,<br>
Srikanth k Potluri<br>
+63 9177444783(philippines) <br>
<BR></HTML>