Skip to content

Instantly share code, notes, and snippets.

View SrivastavaAnubhav's full-sized avatar
😁

Anubhav Srivastava SrivastavaAnubhav

😁
View GitHub Profile
@SrivastavaAnubhav
SrivastavaAnubhav / scan_perf.txt
Created June 30, 2023 17:41
TCMalloc 1 MB sampling perf scan workload
YAML_NAME(version) WORKLOAD BASELINE-(Baseline)↓ 1 MB SAMPLING↓ 1 MB SAMPLING/BASELINE↓
scanG10_seqscan_increasingTabletCount(v1.0) scanG10_noIndex_fullTable_seqScan_1M_rows_12tablets 186.79 189.94 1.02
scanG10_seqscan_increasingTabletCount(v1.0) scanG10_noIndex_fullTable_seqScan_1M_rows_3tablets 205.69 215.13 1.05
scanG10_seqscan_increasingTabletCount(v1.0) scanG10_noIndex_fullTable_seqScan_1M_rows_6tablets 185.28 188.21 1.02
scanG1_hash_pointlookup_primarykey_vs_index(v1.0) scanG1_indx_hash_point_lookup 0.35 0.33 0.94
scanG1_hash_pointlookup_primarykey_vs_index(v1.0) scanG1_pkey_hash_point_lookup 0.35 0.33 0.94
scanG2_pkey_rangeScan_increasingRows(v1.0) scanG2_pkey_rangescan_varying_rows_100Krows 87.28 97.78 1.12
scanG2_pkey_rangeScan_increasingRows(v1.0) scanG2_pkey_rangescan_varying_rows_1Mrows 861.9 990.19 1.15
scanG2_pkey_rangeScan_increasingRows(v1.0) scanG2_pkey_rangescan_varying_rows_1row 0.35 0.34 0.97
scanG2_pkey_rangeScan_increasingRows(v1.0) scanG2_pkey_rangescan_varying_rows_500Krows 422.23 486.
@SrivastavaAnubhav
SrivastavaAnubhav / sysbench_multi_insert.txt
Created June 23, 2023 05:17
Google TCMalloc 100 KB sampling perf
Name Type LATEST MASTER BRANCH (1854602) SELECTED TEST-ID (1854902) SELECTED TEST-ID/LATEST MASTER BRANCH
Results Average Latency(ms) 40.35 39.88 0.99
95th percentile Latency(ms) 64.47 63.32 0.98
Throughput:events/s 594.71 601.78 1.01
TotalOperations 10704986.0 10832142.0 1.01
YSQL Throughput Total YSQL Ops/sec 6020.22 6085.85 -
YSQL Ops/sec Select Ops/sec 0.07 0.05 -
Update Ops/sec 0.0 0.0 -
Insert Ops/sec 6020.08 6085.75 -
Delete Ops/sec 0.07 0.05 -