Postgres Pro
Downloads
Home   >   mailing lists

how to improve COPY timings or reduce data loading time using copy - Mailing list pgsql-admin

From Potluri Srikanth
Subject how to improve COPY timings or reduce data loading time using copy
Date
Msg-id 57026.1206944812@ismartpanache.com
Whole thread Raw
Responses Re: how to improve COPY timings or reduce data loading time using copy
List pgsql-admin
Tree view 
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
todrop 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 />
postgresversion : 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 />

pgsql-admin by date:

Previous
From: "Phillip Smith"
Date:
Subject: Re: weird network issue
Next
From: Achilleas Mantzios
Date:
Subject: Re: off-topic - list files on linux