On 06/19/2018 03:14 PM, Ravi Krishna wrote:
>> If performance is relevant then your app should probably be using COPY protocol, not line by line inserts. It's
>> supported by most postgresql access libraries. If your app does that then using "\copy" from psql would be
>> an appropriate benchmark.
> Actually the reluctance to not use COPY is to make the benchmark same across two different RDBMS in
> two diff env.
If bulk loading is the actual production target, all your RDBMS choices
have their own loaders. I suggest that is what you ought tocompare.