Skip to content

Instantly share code, notes, and snippets.

@mdcallag

mdcallag/gist:1a805405533a8068ab7e37d52cbcd3f0

Created December 6, 2021 19:20
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save mdcallag/1a805405533a8068ab7e37d52cbcd3f0 to your computer and use it in GitHub Desktop.
Save mdcallag/1a805405533a8068ab7e37d52cbcd3f0 to your computer and use it in GitHub Desktop.
Download ZIP
400m rows, 1800 secs
Raw
gistfile1.txt
db_1 = x.pg124.x5.pk1
db_2 = x.pg134.x5.pk1
db_3 = x.pg140.x5.pk1
db_1 db_2 db_3
1.00 1.12 1.13 point-query.warm.range100.pk1
1.00 0.99 1.05 point-query.pre.range100.pk1
1.00 1.00 1.02 random-points.pre.range10.pk1
1.00 1.00 1.02 random-points.pre.range100.pk1
1.00 1.00 1.00 random-points.pre.range1000.pk1
1.00 0.95 1.04 read-only.pre.range10.pk1
1.00 0.98 1.02 read-only.pre.range100.pk1
1.00 1.00 1.00 read-only.pre.range10000.pk1
1.00 0.99 0.99 points-covered-pk.pre.range100.pk1
1.00 0.98 1.00 points-notcovered-pk.pre.range100.pk1
1.00 1.00 1.00 points-covered-si.pre.range100.pk1
1.00 1.04 1.07 points-notcovered-si.pre.range100.pk1
1.00 1.01 0.98 range-covered-pk.pre.range100.pk1
1.00 0.99 1.01 range-notcovered-pk.pre.range100.pk1
1.00 0.99 0.98 range-covered-si.pre.range100.pk1
1.00 1.00 1.01 range-notcovered-si.pre.range100.pk1
1.00 0.98 0.94 update-inlist.range100.pk1
1.00 0.97 0.96 update-index.range100.pk1
1.00 1.01 0.98 update-nonindex.range100.pk1
1.00 0.99 1.00 update-one.range100.pk1
1.00 1.00 0.97 update-zipf.range100.pk1
1.00 1.02 1.00 write-only.range10000.pk1
1.00 1.02 1.03 read-write.range10.pk1
1.00 1.02 1.07 read-only.range10.pk1
1.00 0.99 1.00 read-only.range100.pk1
1.00 1.00 1.00 read-only.range10000.pk1
1.00 1.05 1.02 point-query.range100.pk1
1.00 1.00 1.01 random-points.range10.pk1
1.00 1.00 1.00 random-points.range100.pk1
1.00 1.00 1.00 random-points.range1000.pk1
1.00 0.96 0.98 hot-points.range100.pk1
1.00 0.98 0.99 points-covered-pk.range100.pk1
1.00 1.00 1.02 points-notcovered-pk.range100.pk1
1.00 1.00 1.00 points-covered-si.range100.pk1
1.00 1.05 1.07 points-notcovered-si.range100.pk1
1.00 1.01 0.98 range-covered-pk.range100.pk1
1.00 0.98 1.00 range-notcovered-pk.range100.pk1
1.00 1.02 0.99 range-covered-si.range100.pk1
1.00 1.00 1.00 range-notcovered-si.range100.pk1
1.00 0.84 0.93 scan.range100.pk1
1.00 1.01 0.99 delete.range100.pk1
1.00 1.04 0.93 insert.range100.pk1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment