Skip site navigation (1)
Skip section navigation (2)
Hi team,
I am using COPY to load data in my tables from CSV file.
File size : 16 gb
time taken to drop index + truncate data + load data + apply index is : 1.5 hrs.
how can i reduce the time ?
OS : SOLARIS 10
Machine : THUMPER (x4500, SUN )
Datatbase : greenplum (based on postgresql)
postgres version : 8.4
greenplum version : 3.0.0.2
Your suggestion will be of great help to me .
Thanks & Regards,
Srikanth k Potluri
+63 9177444783(philippines)
Peripheral Links
Header And Logo
|
Site Navigation
how to improve COPY timings or reduce data loading time using copy
- From: "Potluri Srikanth" <spotluri(at)ismartpanache(dot)com>
- To: <pgsql-admin(at)postgresql(dot)org>
- Subject: how to improve COPY timings or reduce data loading time using copy
- Date: Mon, 31 Mar 2008 01:26:52 -0500
Hi team,
I am using COPY to load data in my tables from CSV file.
File size : 16 gb
time taken to drop index + truncate data + load data + apply index is : 1.5 hrs.
how can i reduce the time ?
OS : SOLARIS 10
Machine : THUMPER (x4500, SUN )
Datatbase : greenplum (based on postgresql)
postgres version : 8.4
greenplum version : 3.0.0.2
Your suggestion will be of great help to me .
Thanks & Regards,
Srikanth k Potluri
+63 9177444783(philippines)
- Follow-Ups:
- Re: how to improve COPY timings or reduce data loading time using copy
- From: hubert depesz lubaczewski
- Re: how to improve COPY timings or reduce data loading time using copy
- Prev by Date: Re: weird network issue
- Next by Date: Re: off-topic - list files on linux
- Previous by thread: bacula problem - failures with no error message in postgres?
- Next by thread: Re: how to improve COPY timings or reduce data loading time using copy
- Indexes: