pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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 &amp; Regards,<br>
Srikanth k Potluri<br>
+63 9177444783(philippines) <br>


<BR></HTML>




view thread (2+ messages)  latest in thread

Message-ID: <57026.1206944812@ismartpanache.com>
Permalink:  ../57026.1206944812@ismartpanache.com/
Also on:    postgresql.org/message-id/57026.1206944812@ismartpanache.com

 · 

reply

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