Skip to content

Instantly share code, notes, and snippets.

View yuzefovich's full-sized avatar

Yahor Yuzefovich yuzefovich

29 followers · 0 following
  • Cockroach Labs
  • San Francisco, CA
View GitHub Profile
@yuzefovich
yuzefovich / 120529 benchmarks
Created March 15, 2024 06:52
name old time/op new time/op delta
BoundAccountGrow-24 2.07ns ± 0% 2.08ns ± 1% +0.47% (p=0.003 n=10+10)
TraverseTree/levels=2/children=2-24 79.3ns ± 4% 62.0ns ± 5% -21.88% (p=0.000 n=10+10)
TraverseTree/levels=2/children=4-24 122ns ± 1% 102ns ± 4% -16.28% (p=0.000 n=9+10)
TraverseTree/levels=2/children=8-24 214ns ± 2% 185ns ± 0% -13.40% (p=0.000 n=9+9)
TraverseTree/levels=4/children=2-24 445ns ± 1% 307ns ± 1% -31.12% (p=0.000 n=8+10)
TraverseTree/levels=4/children=4-24 2.23µs ± 0% 1.73µs ± 0% -22.34% (p=0.000 n=10+9)
TraverseTree/levels=4/children=8-24 15.9µs ± 0% 12.2µs ± 0% -23.59% (p=0.000 n=9+10)
TraverseTree/levels=8/children=2-24 8.01µs ± 0% 5.29µs ± 0% -33.90% (p=0.000 n=9+10)
TraverseTree/levels=8/children=4-24 669µs ± 1% 478µs ± 1% -28.54% (p=0.000 n=10+10)
@yuzefovich
yuzefovich / 118556 hash aggregator bench
Last active February 1, 2024 22:26
Aggregator/ANY_NOT_NULL/hash/int/groupSize=1/numInputRows=1-24 13.2µs ± 6% 11.2µs ± 5% -15.16% (p=0.000 n=10+10)
Aggregator/ANY_NOT_NULL/hash/int/groupSize=1/numInputRows=32-24 18.1µs ± 5% 15.0µs ± 4% -17.08% (p=0.000 n=10+9)
Aggregator/ANY_NOT_NULL/hash/int/groupSize=2/numInputRows=32-24 17.2µs ± 4% 13.8µs ± 3% -19.90% (p=0.000 n=10+10)
Aggregator/ANY_NOT_NULL/hash/int/groupSize=32/numInputRows=32-24 14.9µs ± 2% 11.9µs ± 7% -20.27% (p=0.000 n=10+10)
Aggregator/ANY_NOT_NULL/hash/int/groupSize=1/numInputRows=1024-24 169µs ± 2% 164µs ± 2% -2.91% (p=0.000 n=10+10)
Aggregator/ANY_NOT_NULL/hash/int/groupSize=2/numInputRows=1024-24 144µs ± 2% 140µs ± 2% -2.29% (p=0.000 n=10+10)
Aggregator/ANY_NOT_NULL/hash/int/groupSize=32/numInputRows=1024-24 62.1µs ± 5% 60.7µs ± 3% -2.17% (p=0.043 n=10+10)
Aggregator/ANY_NO
@yuzefovich
yuzefovich / 117116 bench
Created January 17, 2024 17:10
Select1/Cockroach-24 114µs ± 4% 119µs ± 5% +4.24% (p=0.004 n=10+10)
Select1/SharedProcessTenantCockroach-24 141µs ± 3% 143µs ± 2% ~ (p=0.182 n=10+9)
Select1/MultinodeCockroach-24 121µs ± 2% 127µs ± 3% +5.16% (p=0.000 n=10+10)
Select2/Cockroach-24 547µs ± 2% 562µs ± 1% +2.83% (p=0.000 n=9+9)
Select2/SharedProcessTenantCockroach-24 594µs ± 1% 611µs ± 1% +2.89% (p=0.000 n=10+9)
Select2/MultinodeCockroach-24 1.09ms ± 2% 1.11ms ± 2% +2.38% (p=0.000 n=10+9)
Select3/Cockroach-24
@yuzefovich
yuzefovich / 117649 colexec benchmarks
Last active January 12, 2024 22:33
Aggregator/ANY_NOT_NULL/hash/int/groupSize=1/numInputRows=1-24 12.3µs ± 3% 11.5µs ± 1% -6.80% (p=0.000 n=10+10)
Aggregator/ANY_NOT_NULL/hash/int/groupSize=1/numInputRows=32-24 16.8µs ± 2% 15.8µs ± 4% -6.36% (p=0.000 n=10+10)
Aggregator/ANY_NOT_NULL/hash/int/groupSize=2/numInputRows=32-24 15.3µs ± 2% 14.8µs ± 5% -3.44% (p=0.043 n=10+10)
Aggregator/ANY_NOT_NULL/hash/int/groupSize=32/numInputRows=32-24 13.0µs ± 1% 13.0µs ± 4% ~ (p=0.853 n=10+10)
Aggregator/ANY_NOT_NULL/hash/int/groupSize=1/numInputRows=1024-24 153µs ± 3% 153µs ± 1% ~ (p=0.905 n=10+9)
Aggregator/ANY_NOT_NULL/hash/int/groupSize=2/numInputRows=1024-24
@yuzefovich
yuzefovich / postgres tutorial setup, last
Created November 19, 2023 22:28
SELECT pg_catalog.setval('public.actor_actor_id_seq', 200, true);
SELECT pg_catalog.setval('public.address_address_id_seq', 605, true);
SELECT pg_catalog.setval('public.category_category_id_seq', 16, true);
SELECT pg_catalog.setval('public.city_city_id_seq', 600, true);
SELECT pg_catalog.setval('public.country_country_id_seq', 109, true);
@yuzefovich
yuzefovich / postgres tutorial setup, copy
Created November 19, 2023 22:28
-- not everything works
echo "COPY public.actor FROM STDIN WITH CSV DELIMITER '\t';" | cat - 3057.dat | ./cockroach sql --insecure
echo "COPY public.address FROM STDIN WITH CSV DELIMITER '\t';" | cat - 3065.dat | ./cockroach sql --insecure
echo "COPY public.category FROM STDIN WITH CSV DELIMITER '\t';" | cat - 3059.dat | ./cockroach sql --insecure
echo "COPY public.city FROM STDIN WITH CSV DELIMITER '\t';" | cat - 3067.dat | ./cockroach sql --insecure
@yuzefovich
yuzefovich / postgres tutorial setup, initial
Created November 19, 2023 22:27
CREATE TYPE public.mpaa_rating AS ENUM (
'G',
'PG',
'PG-13',
'R',
'NC-17'
);
CREATE SEQUENCE public.customer_customer_id_seq
START WITH 1
@yuzefovich
yuzefovich / 112117
Last active October 16, 2023 22:12
Scan/Cockroach/count=1/limit=0-24 460µs ± 3% 469µs ± 3% ~ (p=0.063 n=10+10)
Scan/Cockroach/count=1/limit=1-24 471µs ± 2% 480µs ± 2% +1.84% (p=0.009 n=10+10)
Scan/Cockroach/count=1/limit=10-24 474µs ± 3% 483µs ± 3% +1.85% (p=0.019 n=10+10)
Scan/Cockroach/count=1/limit=100-24 480µs ± 4% 484µs ± 4% ~ (p=0.436 n=10+10)
Scan/Cockroach/count=10/limit=0-24 490µs ± 5% 492µs ± 2% ~ (p=0.497 n=10+9)
Scan/Cockroach/count=10/limit=1-24 479µs ± 2% 473µs ± 1% -1.42% (p=0.021 n=9+8)
Scan/Cockroach/count=10/limit=10-24 490µs ± 2% 491µs ± 2% ~ (p=0.631 n=10+10)
Scan/Cockroach/count=10/limit=100-24 490µs ± 2% 496µs ± 2% +1.27
@yuzefovich
yuzefovich / 111724 BenchmarkScan_Cockroach
Last active October 5, 2023 04:04
Note that a single "regression" seemed to be a fluke, because running just one config right away resulted in
name old time/op new time/op delta
Scan/Cockroach/count=10000/limit=1-24 341µs ± 2% 339µs ± 1% ~ (p=0.481 n=10+10)
name old alloc/op new alloc/op delta
Scan/Cockroach/count=10000/limit=1-24 32.3kB ±23% 32.2kB ±22% ~ (p=0.796 n=9+9)
name old allocs/op new allocs/op delta
Scan/Cockroach/count=10000/limit=1-24 339 ± 8% 343 ± 9% ~ (p=0.683 n=9+9)
@yuzefovich
yuzefovich / 110712 trace
Created September 29, 2023 04:32
0.000ms 0.000ms === operation:re-running trace _verbose:1 node:4 client:127.0.0.1:57758 hostssl: user:root intExec:system-jobs-scan
0.000ms 0.000ms [colbatchscan: {count: 3, duration 18.5s, unfinished}]
0.000ms 0.000ms [dist sender send: {count: 12, duration 15.4s}]
0.000ms 0.000ms [range lookup: {count: 12, duration 9.2s}]
0.000ms 0.000ms [flow: {count: 1, duration 6.2s}]
0.000ms 0.000ms [flow coordinator: {count: 1, duration 6.2s}]
0.000ms 0.000ms [materializer: {count: 1, duration 6.2s}]
0.000ms 0.000ms [txn coordinator send: {count: 3, duration 6.2s}]
0.000ms 0.000ms [/cockroach.roachpb.Internal/Batch: {count: 55, duration 24ms}]
0.568ms 0.568ms event:sql/distsql_running.go:815 [n4,client=127.0.0.1:57758,hostssl,user=root,intExec=system-jobs-scan] plan diagram URL: