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.
