COPY FROM instead of INSERT INTO

wergstatt / pprkrkn

0 stars 0 forks source link

COPY FROM instead of INSERT INTO #2

Closed wergstatt closed 4 years ago

wergstatt commented 4 years ago

The baseline implementation of #1 employs insert into statements, which are supposed to be quite slow. As triggers in postgres are also invoked by copy from statements, which seems to be a difference to IBM DB2, this should massively improve performance.

[x] use a copy from load routine.

wergstatt commented 4 years ago

Journals are finally loaded via COPY at the cost of preprocessing data in Python (compare #3 )