From: Potluri Srikanth <spotluri@ismartpanache.com>
To: pgsql-performance@postgresql.org
Subject: bulk data loading
Date: Mon, 7 Apr 2008 22:41:47 -0500
Message-ID: <41583.1207626107@ismartpanache.com> (raw)
<HTML>
Hi all,<br>
<br>
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.<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="font-weight: bold;"><br>
</span><blockquote style="border-left: 2px solid rgb(245, 245, 245); margin-left: 5px; margin-right: 0px; padding-left: 5px; padding-right: 0px;"><br>
</blockquote><BR></HTML>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: spotluri@ismartpanache.com
Subject: Re: bulk data loading
In-Reply-To: <41583.1207626107@ismartpanache.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox