Small set of pictures comparing three test cases:
- Postgres with data stored on SSD/NVMe disk
- Postgres with data stored on SSD/SATA disk
- MySQL (MariaDB 5.5.50) with data stored on SSD/SATA disk
- PK on DiaObject table is (htmId20, diaObjectId, validityStart) like in the previous tests
Note that MariaDB used out-of box setup with a standard buffer sizes which is probably not adequate, I'll test different configuration later.
Plots for reading performance:
Plots for writing performance: