Received: from localhost (unknown [200.46.204.184]) by developer.postgresql.org (Postfix) with ESMTP id 53CDF2E002D for ; Mon, 31 Mar 2008 03:26:54 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 79211-06 for ; Mon, 31 Mar 2008 03:26:51 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from app01.sm.onr.chicago.hostway (fw.mfg.onr.siteprotect.com [64.26.60.152]) by developer.postgresql.org (Postfix) with ESMTP id EBAB72E002C for ; Mon, 31 Mar 2008 03:26:53 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by app01.sm.onr.chicago.hostway (Postfix) with ESMTP id 9B5AE8DC0E4 for ; Mon, 31 Mar 2008 01:26:52 -0500 (CDT) MIME-Version: 1.0 X-Mailer: AtMail PHP 5.04 Message-ID: <57026.1206944812@ismartpanache.com> To: Reply-To: spotluri@ismartpanache.com Content-Type: text/html; charset="utf-8" X-Origin: 203.84.191.122 Date: Mon, 31 Mar 2008 01:26:52 -0500 Subject: how to improve COPY timings or reduce data loading time using copy From: "Potluri Srikanth" Content-Transfer-Encoding: quoted-printable X-Archive-Number: 200803/266 X-Sequence-Number: 28749 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)