khatru-sqlite_results.txt raw
1 Starting Nostr Relay Benchmark (Badger Backend)
2 Data Directory: /tmp/benchmark_khatru-sqlite_8
3 Events: 50000, Workers: 24, Duration: 1m0s
4 1764801029566947ℹ️ migrating to version 1... /build/pkg/database/migrations.go:68
5 1764801029567062ℹ️ migrating to version 2... /build/pkg/database/migrations.go:75
6 1764801029567087ℹ️ migrating to version 3... /build/pkg/database/migrations.go:82
7 1764801029567092ℹ️ cleaning up ephemeral events (kinds 20000-29999)... /build/pkg/database/migrations.go:304
8 1764801029567102ℹ️ cleaned up 0 ephemeral events from database /build/pkg/database/migrations.go:349
9 1764801029567115ℹ️ migrating to version 4... /build/pkg/database/migrations.go:89
10 1764801029567122ℹ️ converting events to optimized inline storage (Reiser4 optimization)... /build/pkg/database/migrations.go:357
11 1764801029567131ℹ️ found 0 events to convert (0 regular, 0 replaceable, 0 addressable) /build/pkg/database/migrations.go:446
12 1764801029567137ℹ️ migration complete: converted 0 events to optimized inline storage, deleted 0 old keys /build/pkg/database/migrations.go:555
13 1764801029567154ℹ️ migrating to version 5... /build/pkg/database/migrations.go:96
14 1764801029567160ℹ️ re-encoding events with optimized tag binary format... /build/pkg/database/migrations.go:562
15 1764801029567169ℹ️ found 0 events with e/p tags to re-encode /build/pkg/database/migrations.go:649
16 1764801029567174ℹ️ no events need re-encoding /build/pkg/database/migrations.go:652
17 1764801029567187ℹ️ migrating to version 6... /build/pkg/database/migrations.go:103
18 1764801029567192ℹ️ converting events to compact serial-reference format... /build/pkg/database/migrations.go:706
19 1764801029567211ℹ️ found 0 events to convert to compact format /build/pkg/database/migrations.go:846
20 1764801029567217ℹ️ no events need conversion /build/pkg/database/migrations.go:849
21
22 ╔════════════════════════════════════════════════════════╗
23 ║ BADGER BACKEND BENCHMARK SUITE ║
24 ╚════════════════════════════════════════════════════════╝
25
26 === Starting Badger benchmark ===
27 RunPeakThroughputTest (Badger)..
28
29 === Peak Throughput Test ===
30 2025/12/03 22:30:29 INFO: Successfully loaded embedded libsecp256k1 v5.0.0 from /tmp/orly-libsecp256k1/libsecp256k1.so
31 Events saved: 50000/50000 (100.0%), errors: 0
32 Duration: 2.852065909s
33 Events/sec: 17531.15
34 Avg latency: 1.233875ms
35 P90 latency: 1.547505ms
36 P95 latency: 1.713051ms
37 P99 latency: 3.452631ms
38 Bottom 10% Avg latency: 707.713µs
39 Wiping database between tests...
40 RunBurstPatternTest (Badger)..
41
42 === Burst Pattern Test ===
43 Burst completed: 5000 events in 297.229736ms
44 Burst completed: 5000 events in 291.618719ms
45 Burst completed: 5000 events in 295.763107ms
46 Burst completed: 5000 events in 320.083794ms
47 Burst completed: 5000 events in 306.954958ms
48 Burst completed: 5000 events in 294.350551ms
49 Burst completed: 5000 events in 266.492151ms
50 Burst completed: 5000 events in 258.415169ms
51 Burst completed: 5000 events in 279.574451ms
52 Burst completed: 5000 events in 274.042853ms
53 Burst test completed: 50000 events in 7.891576755s, errors: 0
54 Events/sec: 6335.87
55 Wiping database between tests...
56 RunMixedReadWriteTest (Badger)..
57
58 === Mixed Read/Write Test ===
59 Generating 1000 unique synthetic events (minimum 300 bytes each)...
60 Generated 1000 events:
61 Average content size: 312 bytes
62 All events are unique (incremental timestamps)
63 All events are properly signed
64
65 Pre-populating database for read tests...
66 Generating 50000 unique synthetic events (minimum 300 bytes each)...
67 Generated 50000 events:
68 Average content size: 314 bytes
69 All events are unique (incremental timestamps)
70 All events are properly signed
71
72 Mixed test completed: 25000 writes, 25000 reads in 24.900476855s
73 Combined ops/sec: 2007.99
74 Wiping database between tests...
75 RunQueryTest (Badger)..
76
77 === Query Test ===
78 Generating 10000 unique synthetic events (minimum 300 bytes each)...
79 Generated 10000 events:
80 Average content size: 313 bytes
81 All events are unique (incremental timestamps)
82 All events are properly signed
83
84 Pre-populating database with 10000 events for query tests...
85 Query test completed: 410621 queries in 1m0.004293618s
86 Queries/sec: 6843.19
87 Avg query latency: 2.208463ms
88 P95 query latency: 8.264ms
89 P99 query latency: 12.52398ms
90 Wiping database between tests...
91 RunConcurrentQueryStoreTest (Badger)..
92
93 === Concurrent Query/Store Test ===
94 Generating 5000 unique synthetic events (minimum 300 bytes each)...
95 Generated 5000 events:
96 Average content size: 313 bytes
97 All events are unique (incremental timestamps)
98 All events are properly signed
99
100 Pre-populating database with 5000 events for concurrent query/store test...
101 Generating 50000 unique synthetic events (minimum 300 bytes each)...
102 Generated 50000 events:
103 Average content size: 314 bytes
104 All events are unique (incremental timestamps)
105 All events are properly signed
106
107 Concurrent test completed: 308780 operations (258780 queries, 50000 writes) in 1m0.002949862s
108 Operations/sec: 5146.08
109 Avg latency: 1.517721ms
110 Avg query latency: 1.590458ms
111 Avg write latency: 1.141264ms
112 P95 latency: 3.798681ms
113 P99 latency: 9.90181ms
114
115 === Badger benchmark completed ===
116
117
118 ================================================================================
119 BENCHMARK REPORT
120 ================================================================================
121
122 Test: Peak Throughput
123 Duration: 2.852065909s
124 Total Events: 50000
125 Events/sec: 17531.15
126 Success Rate: 100.0%
127 Concurrent Workers: 24
128 Memory Used: 288 MB
129 Avg Latency: 1.233875ms
130 P90 Latency: 1.547505ms
131 P95 Latency: 1.713051ms
132 P99 Latency: 3.452631ms
133 Bottom 10% Avg Latency: 707.713µs
134 ----------------------------------------
135
136 Test: Burst Pattern
137 Duration: 7.891576755s
138 Total Events: 50000
139 Events/sec: 6335.87
140 Success Rate: 100.0%
141 Concurrent Workers: 24
142 Memory Used: 282 MB
143 Avg Latency: 1.239192ms
144 P90 Latency: 1.634621ms
145 P95 Latency: 1.880869ms
146 P99 Latency: 3.451389ms
147 Bottom 10% Avg Latency: 633.361µs
148 ----------------------------------------
149
150 Test: Mixed Read/Write
151 Duration: 24.900476855s
152 Total Events: 50000
153 Events/sec: 2007.99
154 Success Rate: 100.0%
155 Concurrent Workers: 24
156 Memory Used: 179 MB
157 Avg Latency: 632.275µs
158 P90 Latency: 820.942µs
159 P95 Latency: 918.848µs
160 P99 Latency: 1.159557ms
161 Bottom 10% Avg Latency: 3.463779ms
162 ----------------------------------------
163
164 Test: Query Performance
165 Duration: 1m0.004293618s
166 Total Events: 410621
167 Events/sec: 6843.19
168 Success Rate: 100.0%
169 Concurrent Workers: 24
170 Memory Used: 183 MB
171 Avg Latency: 2.208463ms
172 P90 Latency: 6.696276ms
173 P95 Latency: 8.264ms
174 P99 Latency: 12.52398ms
175 Bottom 10% Avg Latency: 9.093268ms
176 ----------------------------------------
177
178 Test: Concurrent Query/Store
179 Duration: 1m0.002949862s
180 Total Events: 308780
181 Events/sec: 5146.08
182 Success Rate: 100.0%
183 Concurrent Workers: 24
184 Memory Used: 137 MB
185 Avg Latency: 1.517721ms
186 P90 Latency: 3.086927ms
187 P95 Latency: 3.798681ms
188 P99 Latency: 9.90181ms
189 Bottom 10% Avg Latency: 5.471135ms
190 ----------------------------------------
191
192 Report saved to: /tmp/benchmark_khatru-sqlite_8/benchmark_report.txt
193 AsciiDoc report saved to: /tmp/benchmark_khatru-sqlite_8/benchmark_report.adoc
194
195 RELAY_NAME: khatru-sqlite
196 RELAY_URL: ws://khatru-sqlite:3334
197 TEST_TIMESTAMP: 2025-12-03T22:33:46+00:00
198 BENCHMARK_CONFIG:
199 Events: 50000
200 Workers: 24
201 Duration: 60s
202