Another interesting thing is that for 250 records COPY is actually the slowest. But these are real world tests to that could have been the time it took to transform the 250 records to CSV.
I did a benchmark and multi-row insert with a single statement is about 6-7% faster than batch insert. This is for 250 rows executed a thousand times in a loop (alternating between the two to reduce subsequent table insert index slowdown). So a little faster but not significantly so.
Yes that's correct. A multiple row insert with a single insert statement. I'll try benchmarking the two on Monday. My guess is that they are pretty damn similar.
Sent from my iPhone
On Jun 6, 2015, at 10:35 AM, Dave Cramer <pg@fastcrypt.com> wrote: