All tests are run on an instance of Azure Database for PostgreSQL Flexible Server, Standard_D16ds_v4 (16 vcpus, 64 GiB memory), with 256 GiB / 2300 iops storage.

test_loadFromSingleCSV : time, 30.34, chunk_size: 3, direct_loading: False, use_copy: False
test_loadFromSingleCSV : time, 17.55, chunk_size: 3, direct_loading: True, use_copy: False
test_loadFromSingleCSV : time, 4.73, chunk_size: 3, direct_loading: False, use_copy: True
test_loadFromSingleCSV done

(test) rifujita@macstudio test % ./test_agefreighter.py
test_loadFromSingleCSV : time, 61.86, chunk_size: 128, direct_loading: False, use_copy: False
test_loadFromSingleCSV : time, 5.69, chunk_size: 128, direct_loading: True, use_copy: False
test_loadFromSingleCSV : time, 5.51, chunk_size: 128, direct_loading: False, use_copy: True
test_loadFromSingleCSV done

test_loadFromCSVs : time, 17.42, chunk_size: 128, direct_loading: False, use_copy: False
test_loadFromCSVs : time, 4.63, chunk_size: 128, direct_loading: True, use_copy: False
test_loadFromCSVs : time, 5.34, chunk_size: 128, direct_loading: False, use_copy: True
test_loadFromCSVs done

test_loadFromNetworkx : time, 28.76, chunk_size: 128, direct_loading: False, use_copy: False
test_loadFromNetworkx : time, 5.92, chunk_size: 128, direct_loading: True, use_copy: False
test_loadFromNetworkx : time, 5.71, chunk_size: 128, direct_loading: False, use_copy: True
test_loadFromNetworkx done

test_loadFromNeo4j : time, 51.15, chunk_size: 128, direct_loading: False, use_copy: False
test_loadFromNeo4j : time, 35.80, chunk_size: 128, direct_loading: True, use_copy: False
test_loadFromNeo4j : time, 36.31, chunk_size: 128, direct_loading: False, use_copy: True
test_loadFromNeo4j done
##### The duration for test_loadFromNeo4j depends on the performance of the neo4j server. #####

test_loadFromPGSQL : time, 81.11, chunk_size: 128, direct_loading: False, use_copy: False
test_loadFromPGSQL : time, 8.22, chunk_size: 128, direct_loading: True, use_copy: False
test_loadFromPGSQL : time, 8.42, chunk_size: 128, direct_loading: False, use_copy: True
test_loadFromPGSQL done
##### The duration for test_loadFromPGSQL depends on the performance of the source pgsql server. #####

test_loadFromParquet : time, 70.61, chunk_size: 128, direct_loading: False, use_copy: False
test_loadFromParquet : time, 5.72, chunk_size: 128, direct_loading: True, use_copy: False
test_loadFromParquet : time, 6.13, chunk_size: 128, direct_loading: False, use_copy: True
test_loadFromParquet done
