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 1763839231750842ℹ️ migrating to version 1... /build/pkg/database/migrations.go:66
5 1763839231750901ℹ️ migrating to version 2... /build/pkg/database/migrations.go:73
6 1763839231750925ℹ️ migrating to version 3... /build/pkg/database/migrations.go:80
7 1763839231750931ℹ️ cleaning up ephemeral events (kinds 20000-29999)... /build/pkg/database/migrations.go:294
8 1763839231750941ℹ️ cleaned up 0 ephemeral events from database /build/pkg/database/migrations.go:339
9 1763839231750956ℹ️ migrating to version 4... /build/pkg/database/migrations.go:87
10 1763839231750961ℹ️ converting events to optimized inline storage (Reiser4 optimization)... /build/pkg/database/migrations.go:347
11 1763839231750983ℹ️ found 0 events to convert (0 regular, 0 replaceable, 0 addressable) /build/pkg/database/migrations.go:436
12 1763839231750993ℹ️ migration complete: converted 0 events to optimized inline storage, deleted 0 old keys /build/pkg/database/migrations.go:545
13 1763839231751016ℹ️ migrating to version 5... /build/pkg/database/migrations.go:94
14 1763839231751021ℹ️ re-encoding events with optimized tag binary format... /build/pkg/database/migrations.go:552
15 1763839231751033ℹ️ found 0 events with e/p tags to re-encode /build/pkg/database/migrations.go:639
16 1763839231751038ℹ️ no events need re-encoding /build/pkg/database/migrations.go:642
17
18 ╔════════════════════════════════════════════════════════╗
19 ║ BADGER BACKEND BENCHMARK SUITE ║
20 ╚════════════════════════════════════════════════════════╝
21
22 === Starting Badger benchmark ===
23 RunPeakThroughputTest (Badger)..
24
25 === Peak Throughput Test ===
26 2025/11/22 19:20:31 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
27 2025/11/22 19:20:31 INFO: Successfully loaded libsecp256k1 v5.0.0 from system path: libsecp256k1.so.2
28 Events saved: 50000/50000 (100.0%), errors: 0
29 Duration: 3.76701384s
30 Events/sec: 13273.11
31 Avg latency: 1.732057ms
32 P90 latency: 2.725001ms
33 P95 latency: 3.370931ms
34 P99 latency: 5.636846ms
35 Bottom 10% Avg latency: 803.833µs
36 Wiping database between tests...
37 RunBurstPatternTest (Badger)..
38
39 === Burst Pattern Test ===
40 Burst completed: 5000 events in 324.962224ms
41 Burst completed: 5000 events in 319.788529ms
42 Burst completed: 5000 events in 292.223747ms
43 Burst completed: 5000 events in 297.968607ms
44 Burst completed: 5000 events in 285.831691ms
45 Burst completed: 5000 events in 385.949074ms
46 Burst completed: 5000 events in 290.335776ms
47 Burst completed: 5000 events in 276.875448ms
48 Burst completed: 5000 events in 304.201963ms
49 Burst completed: 5000 events in 273.277754ms
50 Burst test completed: 50000 events in 8.058529464s, errors: 0
51 Events/sec: 6204.61
52 Wiping database between tests...
53 RunMixedReadWriteTest (Badger)..
54
55 === Mixed Read/Write Test ===
56 Generating 1000 unique synthetic events (minimum 300 bytes each)...
57 Generated 1000 events:
58 Average content size: 312 bytes
59 All events are unique (incremental timestamps)
60 All events are properly signed
61
62 Pre-populating database for read tests...
63 Generating 50000 unique synthetic events (minimum 300 bytes each)...
64 Generated 50000 events:
65 Average content size: 314 bytes
66 All events are unique (incremental timestamps)
67 All events are properly signed
68
69 Mixed test completed: 25000 writes, 25000 reads in 24.559984136s
70 Combined ops/sec: 2035.83
71 Wiping database between tests...
72 RunQueryTest (Badger)..
73
74 === Query Test ===
75 Generating 10000 unique synthetic events (minimum 300 bytes each)...
76 Generated 10000 events:
77 Average content size: 313 bytes
78 All events are unique (incremental timestamps)
79 All events are properly signed
80
81 Pre-populating database with 10000 events for query tests...
82 Query test completed: 382812 queries in 1m0.004759428s
83 Queries/sec: 6379.69
84 Avg query latency: 1.753564ms
85 P95 query latency: 7.120429ms
86 P99 query latency: 11.234021ms
87 Wiping database between tests...
88 RunConcurrentQueryStoreTest (Badger)..
89
90 === Concurrent Query/Store Test ===
91 Generating 5000 unique synthetic events (minimum 300 bytes each)...
92 Generated 5000 events:
93 Average content size: 313 bytes
94 All events are unique (incremental timestamps)
95 All events are properly signed
96
97 Pre-populating database with 5000 events for concurrent query/store test...
98 Generating 50000 unique synthetic events (minimum 300 bytes each)...
99 Generated 50000 events:
100 Average content size: 314 bytes
101 All events are unique (incremental timestamps)
102 All events are properly signed
103
104 Concurrent test completed: 310209 operations (260209 queries, 50000 writes) in 1m0.002874017s
105 Operations/sec: 5169.90
106 Avg latency: 1.497119ms
107 Avg query latency: 1.472534ms
108 Avg write latency: 1.625063ms
109 P95 latency: 3.842736ms
110 P99 latency: 6.293151ms
111
112 === Badger benchmark completed ===
113
114
115 ================================================================================
116 BENCHMARK REPORT
117 ================================================================================
118
119 Test: Peak Throughput
120 Duration: 3.76701384s
121 Total Events: 50000
122 Events/sec: 13273.11
123 Success Rate: 100.0%
124 Concurrent Workers: 24
125 Memory Used: 133 MB
126 Avg Latency: 1.732057ms
127 P90 Latency: 2.725001ms
128 P95 Latency: 3.370931ms
129 P99 Latency: 5.636846ms
130 Bottom 10% Avg Latency: 803.833µs
131 ----------------------------------------
132
133 Test: Burst Pattern
134 Duration: 8.058529464s
135 Total Events: 50000
136 Events/sec: 6204.61
137 Success Rate: 100.0%
138 Concurrent Workers: 24
139 Memory Used: 196 MB
140 Avg Latency: 1.263843ms
141 P90 Latency: 1.851055ms
142 P95 Latency: 2.195471ms
143 P99 Latency: 3.218951ms
144 Bottom 10% Avg Latency: 504.149µs
145 ----------------------------------------
146
147 Test: Mixed Read/Write
148 Duration: 24.559984136s
149 Total Events: 50000
150 Events/sec: 2035.83
151 Success Rate: 100.0%
152 Concurrent Workers: 24
153 Memory Used: 127 MB
154 Avg Latency: 390.903µs
155 P90 Latency: 809.291µs
156 P95 Latency: 905.805µs
157 P99 Latency: 1.149089ms
158 Bottom 10% Avg Latency: 1.046555ms
159 ----------------------------------------
160
161 Test: Query Performance
162 Duration: 1m0.004759428s
163 Total Events: 382812
164 Events/sec: 6379.69
165 Success Rate: 100.0%
166 Concurrent Workers: 24
167 Memory Used: 118 MB
168 Avg Latency: 1.753564ms
169 P90 Latency: 5.356742ms
170 P95 Latency: 7.120429ms
171 P99 Latency: 11.234021ms
172 Bottom 10% Avg Latency: 7.946956ms
173 ----------------------------------------
174
175 Test: Concurrent Query/Store
176 Duration: 1m0.002874017s
177 Total Events: 310209
178 Events/sec: 5169.90
179 Success Rate: 100.0%
180 Concurrent Workers: 24
181 Memory Used: 123 MB
182 Avg Latency: 1.497119ms
183 P90 Latency: 2.998239ms
184 P95 Latency: 3.842736ms
185 P99 Latency: 6.293151ms
186 Bottom 10% Avg Latency: 4.449237ms
187 ----------------------------------------
188
189 Report saved to: /tmp/benchmark_khatru-sqlite_8/benchmark_report.txt
190 AsciiDoc report saved to: /tmp/benchmark_khatru-sqlite_8/benchmark_report.adoc
191
192 RELAY_NAME: khatru-sqlite
193 RELAY_URL: ws://khatru-sqlite:3334
194 TEST_TIMESTAMP: 2025-11-22T19:23:50+00:00
195 BENCHMARK_CONFIG:
196 Events: 50000
197 Workers: 24
198 Duration: 60s
199