2 ms·
For postgres I've been using several threads, each with its own connection, and all going through the same transaction (using the number exported by pg_export_s
by malkia 13y ago
For postgres I've been using several threads, each with its own connection, and all going through the same transaction (using the number exported by pg_export_snapshot()) - with this the speedup is quite big (c++ project using libpq).
I expect that if I move to binary format for inserting it might be even faster. I'm basing this since my reader is binary and that made x3-x4 improvements for my data set/computer/etc.