From: Potluri Srikanth <spotluri@ismartpanache.com>
To: pgsql-admin@postgresql.org
Subject: how to improve COPY timings or reduce data loading time using copy
Date: Mon, 31 Mar 2008 01:26:52 -0500
Message-ID: <57026.1206944812@ismartpanache.com> (raw)
<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>
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-admin@postgresql.org
Cc: spotluri@ismartpanache.com
Subject: Re: how to improve COPY timings or reduce data loading time using copy
In-Reply-To: <57026.1206944812@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