Martijn or any other expert, @schuemie
on postgress we have a medium sized table (86k rows and 1M rows) and the insertTable method is very very slow.
I studied the code for the method and it seems to use DBI::dbWriteTable (but I could not decipher the methods you use.
For medium sized table, can we use dbWriteTable directly. Can you please describe in few sentences what approach insertTable takes and how to best use it. (for medium sized tables)