Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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: unknown_filename
Description: text/html (562 bytes)

Responses

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group