andrew klassen wrote:
You could try materially increasing the update batch size too. As an exercise you could see what the performance of COPY is by backing out the data and reloading it fromI'll try adding more threads to update the table as you suggest.
a suitable file.