Thread: how to improve COPY timings or reduce data loading time using copy

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 /> 

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)