how to improve COPY timings or reduce data loading time using copy

From: "Potluri Srikanth" <spotluri(at)ismartpanache(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: how to improve COPY timings or reduce data loading time using copy
Date: 2008-03-31 06:26:52
Message-ID: 57026.1206944812@ismartpanache.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

<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 &amp; Regards,<br>
Srikanth k Potluri<br>
+63 9177444783(philippines) <br>

<BR></HTML>

Attachment Content-Type Size
unknown_filename text/html 562 bytes

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Achilleas Mantzios 2008-03-31 06:49:04 Re: off-topic - list files on linux
Previous Message Phillip Smith 2008-03-30 23:34:18 Re: weird network issue