Install GRIDSQL 2.0

Hi,

I have installed Gridsql 2.0 . I am trying to test the performance of COPY with respect to Gridsql 1.0.

Please find below the loading time:

grid 1.0
----------
GridSQL -> copy table1 from '/home/postgres/load_test/table1' delimiter ',' CSV;
OK
Response time: 6m 37s 572ms Total time: 6m 37s 572ms

grid 2.0
----------
GridSQL -> copy table1 from '/home/postgres/load_test/table1' delimiter ',' CSV;
OK
Response time: 6m 48s 159ms Total time: 6m 48s 159ms

the file sixe is 9.2 GB and the number of records are 19000000.

I haven't found any significance improvement in the performance of COPY.

Can you please explain me why is it so.

Thanks.

In version 2.0, COPY TO (export) performance was improved, not COPY FROM (import), as was your case.

The 2.0 changes also results in improved performance of row-shipping for cross-node joins.

Regards,

Mason