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