pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedhow 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>
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 & 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 07:51 hubert depesz lubaczewski <depesz@depesz.com>
parent: Potluri Srikanth <spotluri@ismartpanache.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