Skip to content

Instantly share code, notes, and snippets.

View mdcallag's full-sized avatar
🎯
Focusing

Mark Callaghan mdcallag

🎯
Focusing
View GitHub Profile
@mdcallag
mdcallag / o.summ.pg
Created December 1, 2021 01:06
r.10mrows.300s.1u.prep1 - o.summ.pg
point-query.warm.range100.pk1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.000326 0 0 0.881 84033 x.pg124.x5.pk1
0.000310 0 0 0.868 89285 x.pg134.x5.pk1
0.000295 0 0 0.848 88495 x.pg140.x5.pk1
--- relative to first result
0.95 1 1 0.99 1.06 x.pg134.x5.pk1
0.90 1 1 0.96 1.05 x.pg140.x5.pk1
@mdcallag
mdcallag / o.summ.pg
Created December 1, 2021 01:06
r.10mrows.300s.1u.prep0 - o.summ.pg
point-query.warm.range100.pk1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.000327 0 0 0.875 84033 x.pg124.x5.pk1
0.000310 0 0 0.851 89285 x.pg134.x5.pk1
0.000296 0 0 0.848 88495 x.pg140.x5.pk1
--- relative to first result
0.95 1 1 0.97 1.06 x.pg134.x5.pk1
0.91 1 1 0.97 1.05 x.pg140.x5.pk1
@mdcallag
mdcallag / o.summ.my
Created December 1, 2021 01:05
r.400mrows.300s.1u.prep0 - o.summ.my
point-query.warm.range100.pk1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.000320 0.013 0.314 1.271 66856 x.my5649.y8.pk1
0.000312 0.013 0.317 1.247 69601 x.my5735.y8.pk1
0.000497 0.013 0.317 1.235 57413 x.my8020.y8.pk1
0.000421 0.013 0.317 1.236 54149 x.my8022.y8.pk1
0.000427 0.013 0.317 1.236 53490 x.my8023.y8.pk1
0.000412 0.013 0.317 1.235 57151 x.my8026.y8.pk1
0.000495 0.014 0.334 1.259 58539 x.my8027.y8.pk1
@mdcallag
mdcallag / o.summ.my
Created December 1, 2021 01:04
r.10mrows.300s.1u.prep1 - o.summ.my
point-query.warm.range100.pk1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.000284 0 0.072 1.226 81967 x.my5649.y8.pk1
0.000284 0 0.069 0.872 82644 x.my5735.y8.pk1
0.000449 0 0 0.863 64935 x.my8020.y8.pk1
0.000370 0 0 0.865 61728 x.my8022.y8.pk1
0.000366 0 0 0.869 63291 x.my8023.y8.pk1
0.000359 0 0 0.86 65789 x.my8026.y8.pk1
0.000396 0 0.017 0.871 67567 x.my8027.y8.pk1
@mdcallag
mdcallag / gist:f9e974afda0d98ce6afd1ee813fb04e6
Created December 1, 2021 01:03
r.10mrows.300s.1u.prep0 - o.summ.my
point-query.warm.range100.pk1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.000283 0 0.072 1.224 82644 x.my5649.y8.pk1
0.000273 0 0.07 0.854 88495 x.my5735.y8.pk1
0.000438 0 0 0.858 67114 x.my8020.y8.pk1
0.000363 0 0 0.862 63694 x.my8022.y8.pk1
0.000369 0 0 0.862 62893 x.my8023.y8.pk1
0.000352 0 0 0.862 67114 x.my8026.y8.pk1
0.000399 0 0.017 0.888 67114 x.my8027.y8.pk1
@mdcallag
mdcallag / gist:a46d2df7924eed14438ae9a26cc5e279
Created December 1, 2021 00:55
r.400mrows.300s.1u.prep0 - o.sumr.r1.pg
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.89 0.88 point-query.pre.range100.pk1
1.00 1.02 1.01 random-points.pre.range10.pk1
1.00 1.02 1.02 random-points.pre.range100.pk1
1.00 1.20 1.20 random-points.pre.range1000.pk1
@mdcallag
mdcallag / gist:ad81f3869eef8e4ac0e3628a59b08553
Created December 1, 2021 00:55
r.10mrows.300s.1u.prep1 - o.sumr.r1.pg
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.06 1.05 point-query.warm.range100.pk1
1.00 1.00 1.00 point-query.pre.range100.pk1
1.00 0.98 0.99 random-points.pre.range10.pk1
1.00 0.95 0.97 random-points.pre.range100.pk1
1.00 0.95 0.97 random-points.pre.range1000.pk1
@mdcallag
mdcallag / gist:96c4db58348478d502ed2b6a4105f678
Created December 1, 2021 00:54
r.10mrows.300s.1u.prep0 - o.sumr.r1.pg
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.06 1.05 point-query.warm.range100.pk1
1.00 1.00 0.95 point-query.pre.range100.pk1
1.00 0.98 0.98 random-points.pre.range10.pk1
1.00 0.99 0.99 random-points.pre.range100.pk1
1.00 0.99 1.00 random-points.pre.range1000.pk1
@mdcallag
mdcallag / gist:981f65259e5661692efa0dd07bab120b
Created December 1, 2021 00:52
r.400mrows.300s.1u.prep0 - o.sumr.r1.my
db_1 = x.my5649.y8.pk1
db_2 = x.my5735.y8.pk1
db_3 = x.my8020.y8.pk1
db_4 = x.my8022.y8.pk1
db_5 = x.my8023.y8.pk1
db_6 = x.my8026.y8.pk1
db_7 = x.my8027.y8.pk1
db_1 db_2 db_3 db_4 db_5 db_6 db_7
1.00 1.04 0.86 0.81 0.80 0.85 0.88 point-query.warm.range100.pk1
@mdcallag
mdcallag / gist:0b1b6d45bcb19dd89a9a8122352f1166
Created December 1, 2021 00:52
r.10mrows.300s.1u.prep1 - o.sumr.r1.my
db_1 = x.my5649.y8.pk1
db_2 = x.my5735.y8.pk1
db_3 = x.my8020.y8.pk1
db_4 = x.my8022.y8.pk1
db_5 = x.my8023.y8.pk1
db_6 = x.my8026.y8.pk1
db_7 = x.my8027.y8.pk1
db_1 db_2 db_3 db_4 db_5 db_6 db_7
1.00 1.01 0.79 0.75 0.77 0.80 0.82 point-query.warm.range100.pk1