rely-sqlite_results.txt raw
1 Starting Nostr Relay Benchmark (Badger Backend)
2 Data Directory: /tmp/benchmark_rely-sqlite_8
3 Events: 50000, Workers: 24, Duration: 1m0s
4 1763665779574803ℹ️ migrating to version 1... /build/pkg/database/migrations.go:66
5 1763665779574872ℹ️ migrating to version 2... /build/pkg/database/migrations.go:73
6 1763665779574900ℹ️ migrating to version 3... /build/pkg/database/migrations.go:80
7 1763665779574905ℹ️ cleaning up ephemeral events (kinds 20000-29999)... /build/pkg/database/migrations.go:287
8 1763665779574913ℹ️ cleaned up 0 ephemeral events from database /build/pkg/database/migrations.go:332
9 1763665779574927ℹ️ migrating to version 4... /build/pkg/database/migrations.go:87
10 1763665779574932ℹ️ converting events to optimized inline storage (Reiser4 optimization)... /build/pkg/database/migrations.go:340
11 1763665779574942ℹ️ found 0 events to convert (0 regular, 0 replaceable, 0 addressable) /build/pkg/database/migrations.go:429
12 1763665779574947ℹ️ migration complete: converted 0 events to optimized inline storage, deleted 0 old keys /build/pkg/database/migrations.go:538
13
14 ╔════════════════════════════════════════════════════════╗
15 ║ BADGER BACKEND BENCHMARK SUITE ║
16 ╚════════════════════════════════════════════════════════╝
17
18 === Starting Badger benchmark ===
19 RunPeakThroughputTest (Badger)..
20
21 === Peak Throughput Test ===
22 2025/11/20 19:09:39 INFO: Extracted embedded libsecp256k1 to /tmp/orly-libsecp256k1/libsecp256k1.so
23 2025/11/20 19:09:39 WARN: Failed to load embedded library from /tmp/orly-libsecp256k1/libsecp256k1.so: Error relocating /tmp/orly-libsecp256k1/libsecp256k1.so: __fprintf_chk: symbol not found, falling back to system paths
24 2025/11/20 19:09:39 INFO: Successfully loaded libsecp256k1 v5.0.0 from system path: libsecp256k1.so.2
25 Events saved: 50000/50000 (100.0%), errors: 0
26 Duration: 3.135436732s
27 Events/sec: 15946.74
28 Avg latency: 1.397968ms
29 P90 latency: 1.930996ms
30 P95 latency: 2.304287ms
31 P99 latency: 3.616715ms
32 Bottom 10% Avg latency: 755.721µs
33 Wiping database between tests...
34 RunBurstPatternTest (Badger)..
35
36 === Burst Pattern Test ===
37 Burst completed: 5000 events in 303.872847ms
38 Burst completed: 5000 events in 315.659456ms
39 Burst completed: 5000 events in 267.06077ms
40 Burst completed: 5000 events in 307.361928ms
41 Burst completed: 5000 events in 322.693287ms
42 Burst completed: 5000 events in 469.035773ms
43 Burst completed: 5000 events in 312.67366ms
44 Burst completed: 5000 events in 283.102039ms
45 Burst completed: 5000 events in 384.589076ms
46 Burst completed: 5000 events in 420.423539ms
47 Burst test completed: 50000 events in 8.393863388s, errors: 0
48 Events/sec: 5956.73
49 Wiping database between tests...
50 RunMixedReadWriteTest (Badger)..
51
52 === Mixed Read/Write Test ===
53 Generating 1000 unique synthetic events (minimum 300 bytes each)...
54 Generated 1000 events:
55 Average content size: 312 bytes
56 All events are unique (incremental timestamps)
57 All events are properly signed
58
59 Pre-populating database for read tests...
60 Generating 50000 unique synthetic events (minimum 300 bytes each)...
61 Generated 50000 events:
62 Average content size: 314 bytes
63 All events are unique (incremental timestamps)
64 All events are properly signed
65
66 Mixed test completed: 25000 writes, 25000 reads in 24.674556399s
67 Combined ops/sec: 2026.38
68 Wiping database between tests...
69 RunQueryTest (Badger)..
70
71 === Query Test ===
72 Generating 10000 unique synthetic events (minimum 300 bytes each)...
73 Generated 10000 events:
74 Average content size: 313 bytes
75 All events are unique (incremental timestamps)
76 All events are properly signed
77
78 Pre-populating database with 10000 events for query tests...
79 Query test completed: 375290 queries in 1m0.008468905s
80 Queries/sec: 6253.95
81 Avg query latency: 1.790209ms
82 P95 query latency: 7.345664ms
83 P99 query latency: 11.918719ms
84 Wiping database between tests...
85 RunConcurrentQueryStoreTest (Badger)..
86
87 === Concurrent Query/Store Test ===
88 Generating 5000 unique synthetic events (minimum 300 bytes each)...
89 Generated 5000 events:
90 Average content size: 313 bytes
91 All events are unique (incremental timestamps)
92 All events are properly signed
93
94 Pre-populating database with 5000 events for concurrent query/store test...
95 Generating 50000 unique synthetic events (minimum 300 bytes each)...
96 Generated 50000 events:
97 Average content size: 314 bytes
98 All events are unique (incremental timestamps)
99 All events are properly signed
100
101 Concurrent test completed: 314061 operations (264061 queries, 50000 writes) in 1m0.003708095s
102 Operations/sec: 5234.03
103 Avg latency: 1.477392ms
104 Avg query latency: 1.464385ms
105 Avg write latency: 1.546088ms
106 P95 latency: 3.780257ms
107 P99 latency: 5.913557ms
108
109 === Badger benchmark completed ===
110
111
112 ================================================================================
113 BENCHMARK REPORT
114 ================================================================================
115
116 Test: Peak Throughput
117 Duration: 3.135436732s
118 Total Events: 50000
119 Events/sec: 15946.74
120 Success Rate: 100.0%
121 Concurrent Workers: 24
122 Memory Used: 96 MB
123 Avg Latency: 1.397968ms
124 P90 Latency: 1.930996ms
125 P95 Latency: 2.304287ms
126 P99 Latency: 3.616715ms
127 Bottom 10% Avg Latency: 755.721µs
128 ----------------------------------------
129
130 Test: Burst Pattern
131 Duration: 8.393863388s
132 Total Events: 50000
133 Events/sec: 5956.73
134 Success Rate: 100.0%
135 Concurrent Workers: 24
136 Memory Used: 196 MB
137 Avg Latency: 1.477472ms
138 P90 Latency: 2.319807ms
139 P95 Latency: 2.825169ms
140 P99 Latency: 4.502502ms
141 Bottom 10% Avg Latency: 595.131µs
142 ----------------------------------------
143
144 Test: Mixed Read/Write
145 Duration: 24.674556399s
146 Total Events: 50000
147 Events/sec: 2026.38
148 Success Rate: 100.0%
149 Concurrent Workers: 24
150 Memory Used: 142 MB
151 Avg Latency: 387.12µs
152 P90 Latency: 808.479µs
153 P95 Latency: 902.999µs
154 P99 Latency: 1.121415ms
155 Bottom 10% Avg Latency: 1.032694ms
156 ----------------------------------------
157
158 Test: Query Performance
159 Duration: 1m0.008468905s
160 Total Events: 375290
161 Events/sec: 6253.95
162 Success Rate: 100.0%
163 Concurrent Workers: 24
164 Memory Used: 114 MB
165 Avg Latency: 1.790209ms
166 P90 Latency: 5.42081ms
167 P95 Latency: 7.345664ms
168 P99 Latency: 11.918719ms
169 Bottom 10% Avg Latency: 8.275871ms
170 ----------------------------------------
171
172 Test: Concurrent Query/Store
173 Duration: 1m0.003708095s
174 Total Events: 314061
175 Events/sec: 5234.03
176 Success Rate: 100.0%
177 Concurrent Workers: 24
178 Memory Used: 137 MB
179 Avg Latency: 1.477392ms
180 P90 Latency: 2.984261ms
181 P95 Latency: 3.780257ms
182 P99 Latency: 5.913557ms
183 Bottom 10% Avg Latency: 4.281848ms
184 ----------------------------------------
185
186 Report saved to: /tmp/benchmark_rely-sqlite_8/benchmark_report.txt
187 AsciiDoc report saved to: /tmp/benchmark_rely-sqlite_8/benchmark_report.adoc
188
189 RELAY_NAME: rely-sqlite
190 RELAY_URL: ws://rely-sqlite:3334
191 TEST_TIMESTAMP: 2025-11-20T19:12:57+00:00
192 BENCHMARK_CONFIG:
193 Events: 50000
194 Workers: 24
195 Duration: 60s
196