We trying to insert into single CRDB node table one million records, using java postgres jdbc driver, and commit after every 20 rows.
Table for example: CREATE TABLE user(id serial, name string(255), email string(255), url string(255), photo string(255))
My Linux node:
Centos 7.2.2 Linux VM
Intel Xeon E5-2680
HDD(not ssd), XFS
Inserting started at ~100 qps and service latency P99 ~ 500ms,
After first 250 thousands loaded we have range split and perfomance degradation with
10-20 qps and service latency P99 ~ 7 sec.
Part of log:
What we missing? How we can tune this perfomance?