Received: from localhost (unknown [200.46.204.183])
	by developer.postgresql.org (Postfix) with ESMTP id 03CF42E0066
	for <pgsql-performance-postgresql.org@developer.postgresql.org>;
	Tue,  8 Apr 2008 00:42:06 -0300 (ADT)
Received: from developer.postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 61585-03
	for <pgsql-performance-postgresql.org@developer.postgresql.org>;
	Tue,  8 Apr 2008 00:41:54 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.5
Received: from app00.sm.onr.chicago.hostway (fw.mfg.onr.siteprotect.com
	[64.26.60.152])
	by developer.postgresql.org (Postfix) with ESMTP id 9B6C02E006E
	for <pgsql-performance@postgresql.org>;
	Tue,  8 Apr 2008 00:41:49 -0300 (ADT)
Received: from localhost (localhost [127.0.0.1])
	by app00.sm.onr.chicago.hostway (Postfix) with ESMTP id 7E70DD0C0FC
	for <pgsql-performance@postgresql.org>;
	Mon,  7 Apr 2008 22:41:47 -0500 (CDT)
MIME-Version: 1.0
X-Mailer: AtMail PHP 5.04
Message-ID: <41583.1207626107@ismartpanache.com>
To: <pgsql-performance@postgresql.org>
Reply-To: spotluri@ismartpanache.com
Content-Type: text/html; charset="utf-8"
X-Origin: 203.84.191.122
Date: Mon, 7 Apr 2008 22:41:47 -0500
Subject: bulk data loading
From: "Potluri  Srikanth" <spotluri@ismartpanache.com>
Content-Transfer-Encoding: quoted-printable
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=1.673 tagged_above=0 required=5
	tests=HTML_MESSAGE=0.001, MIME_HTML_ONLY=1.672
X-Spam-Level: *
X-Archive-Number: 200804/80
X-Sequence-Number: 29573

<HTML>
Hi all,<br>
<br>
I need to do a bulk data loading around 704GB (log file size) at present&nb=
sp; in 8 hrs (1 am - 9am). The data file size may increase 3 to 5 times in =
future.<br>
<br>
Using COPY it takes 96 hrs to finish the task.<br>
What is the best way to do it ?<br>
<br>
HARDWARE: SUN THUMPER/ RAID10<br>
OS : SOLARIS 10.<br>
DB: Greenplum/Postgres<br>
<br>
<br>
Regards,
<br>
Srikanth k Potluri
<br>
+63 9177444783(philippines) <br>
<br>
<span style=3D"font-weight: bold;"><br>
</span><blockquote style=3D"border-left: 2px solid rgb(245, 245, 245); marg=
in-left: 5px; margin-right: 0px; padding-left: 5px; padding-right: 0px;"><b=
r>

</blockquote><BR></HTML>