pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
how to improve COPY timings  or reduce data loading time using copy
2+ messages / 2 participants
[nested] [flat]

* how to improve COPY timings  or reduce data loading time using copy
@ 2008-03-31 06:26 Potluri  Srikanth <spotluri@ismartpanache.com>
  2008-03-31 07:51 ` Re: how to improve COPY timings or reduce data loading time using copy hubert depesz lubaczewski <depesz@depesz.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Potluri Srikanth @ 2008-03-31 06:26 UTC (permalink / raw)
  To: 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>




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: how to improve COPY timings or reduce data loading time using copy
  2008-03-31 06:26 how to improve COPY timings  or reduce data loading time using copy Potluri  Srikanth <spotluri@ismartpanache.com>
@ 2008-03-31 07:51 ` hubert depesz lubaczewski <depesz@depesz.com>
  0 siblings, 0 replies; 2+ messages in thread

From: hubert depesz lubaczewski @ 2008-03-31 07:51 UTC (permalink / raw)
  To: Potluri Srikanth <spotluri@ismartpanache.com>; +Cc: pgsql-admin

On Mon, Mar 31, 2008 at 01:26:52AM -0500, Potluri  Srikanth wrote:
>    how can i reduce the time ?

try this:
http://pgbulkload.projects.postgresql.org/

depesz

-- 
quicksil1er: "postgres is excellent, but like any DB it requires a
highly paid DBA.  here's my CV!" :)
http://www.depesz.com/ - blog dla ciebie (i moje CV)



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2008-03-31 07:51 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-03-31 06:26 how to improve COPY timings  or reduce data loading time using copy Potluri  Srikanth <spotluri@ismartpanache.com>
2008-03-31 07:51 ` Re: how to improve COPY timings or reduce data loading time using copy hubert depesz lubaczewski <depesz@depesz.com>

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