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 1763838420592113ℹ️ migrating to version 1... /build/pkg/database/migrations.go:66
5 1763838420592185ℹ️ migrating to version 2... /build/pkg/database/migrations.go:73
6 1763838420592206ℹ️ migrating to version 3... /build/pkg/database/migrations.go:80
7 1763838420592211ℹ️ cleaning up ephemeral events (kinds 20000-29999)... /build/pkg/database/migrations.go:294
8 1763838420592221ℹ️ cleaned up 0 ephemeral events from database /build/pkg/database/migrations.go:339
9 1763838420592244ℹ️ migrating to version 4... /build/pkg/database/migrations.go:87
10 1763838420592249ℹ️ converting events to optimized inline storage (Reiser4 optimization)... /build/pkg/database/migrations.go:347
11 1763838420592260ℹ️ found 0 events to convert (0 regular, 0 replaceable, 0 addressable) /build/pkg/database/migrations.go:436
12 1763838420592265ℹ️ migration complete: converted 0 events to optimized inline storage, deleted 0 old keys /build/pkg/database/migrations.go:545
13 1763838420592279ℹ️ migrating to version 5... /build/pkg/database/migrations.go:94
14 1763838420592284ℹ️ re-encoding events with optimized tag binary format... /build/pkg/database/migrations.go:552
15 1763838420592294ℹ️ found 0 events with e/p tags to re-encode /build/pkg/database/migrations.go:639
16 1763838420592300ℹ️ 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:07:00 INFO: Extracted embedded libsecp256k1 to /tmp/orly-libsecp256k1/libsecp256k1.so
27 2025/11/22 19:07:00 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
28 2025/11/22 19:07:00 INFO: Successfully loaded libsecp256k1 v5.0.0 from system path: libsecp256k1.so.2
29 Events saved: 50000/50000 (100.0%), errors: 0
30 Duration: 3.144005095s
31 Events/sec: 15903.28
32 Avg latency: 1.399274ms
33 P90 latency: 1.969161ms
34 P95 latency: 2.34974ms
35 P99 latency: 3.740183ms
36 Bottom 10% Avg latency: 746.992µs
37 Wiping database between tests...
38 RunBurstPatternTest (Badger)..
39
40 === Burst Pattern Test ===
41 Burst completed: 5000 events in 289.665872ms
42 Burst completed: 5000 events in 298.189416ms
43 Burst completed: 5000 events in 284.248905ms
44 Burst completed: 5000 events in 299.878917ms
45 Burst completed: 5000 events in 290.195429ms
46 Burst completed: 5000 events in 335.211169ms
47 Burst completed: 5000 events in 306.221225ms
48 Burst completed: 5000 events in 280.945252ms
49 Burst completed: 5000 events in 270.701091ms
50 Burst completed: 5000 events in 265.342517ms
51 Burst test completed: 50000 events in 7.925705852s, errors: 0
52 Events/sec: 6308.59
53 Wiping database between tests...
54 RunMixedReadWriteTest (Badger)..
55
56 === Mixed Read/Write Test ===
57 Generating 1000 unique synthetic events (minimum 300 bytes each)...
58 Generated 1000 events:
59 Average content size: 312 bytes
60 All events are unique (incremental timestamps)
61 All events are properly signed
62
63 Pre-populating database for read tests...
64 Generating 50000 unique synthetic events (minimum 300 bytes each)...
65 Generated 50000 events:
66 Average content size: 314 bytes
67 All events are unique (incremental timestamps)
68 All events are properly signed
69
70 Mixed test completed: 25000 writes, 25000 reads in 24.557413391s
71 Combined ops/sec: 2036.05
72 Wiping database between tests...
73 RunQueryTest (Badger)..
74
75 === Query Test ===
76 Generating 10000 unique synthetic events (minimum 300 bytes each)...
77 Generated 10000 events:
78 Average content size: 313 bytes
79 All events are unique (incremental timestamps)
80 All events are properly signed
81
82 Pre-populating database with 10000 events for query tests...
83 Query test completed: 388544 queries in 1m0.004756071s
84 Queries/sec: 6475.22
85 Avg query latency: 1.723827ms
86 P95 query latency: 6.917596ms
87 P99 query latency: 10.942489ms
88 Wiping database between tests...
89 RunConcurrentQueryStoreTest (Badger)..
90
91 === Concurrent Query/Store Test ===
92 Generating 5000 unique synthetic events (minimum 300 bytes each)...
93 Generated 5000 events:
94 Average content size: 313 bytes
95 All events are unique (incremental timestamps)
96 All events are properly signed
97
98 Pre-populating database with 5000 events for concurrent query/store test...
99 Generating 50000 unique synthetic events (minimum 300 bytes each)...
100 Generated 50000 events:
101 Average content size: 314 bytes
102 All events are unique (incremental timestamps)
103 All events are properly signed
104
105 Concurrent test completed: 309051 operations (259051 queries, 50000 writes) in 1m0.003409818s
106 Operations/sec: 5150.56
107 Avg latency: 1.532079ms
108 Avg query latency: 1.486246ms
109 Avg write latency: 1.769539ms
110 P95 latency: 4.004134ms
111 P99 latency: 6.701092ms
112
113 === Badger benchmark completed ===
114
115
116 ================================================================================
117 BENCHMARK REPORT
118 ================================================================================
119
120 Test: Peak Throughput
121 Duration: 3.144005095s
122 Total Events: 50000
123 Events/sec: 15903.28
124 Success Rate: 100.0%
125 Concurrent Workers: 24
126 Memory Used: 121 MB
127 Avg Latency: 1.399274ms
128 P90 Latency: 1.969161ms
129 P95 Latency: 2.34974ms
130 P99 Latency: 3.740183ms
131 Bottom 10% Avg Latency: 746.992µs
132 ----------------------------------------
133
134 Test: Burst Pattern
135 Duration: 7.925705852s
136 Total Events: 50000
137 Events/sec: 6308.59
138 Success Rate: 100.0%
139 Concurrent Workers: 24
140 Memory Used: 188 MB
141 Avg Latency: 1.174853ms
142 P90 Latency: 1.682332ms
143 P95 Latency: 1.933092ms
144 P99 Latency: 2.630546ms
145 Bottom 10% Avg Latency: 472.317µs
146 ----------------------------------------
147
148 Test: Mixed Read/Write
149 Duration: 24.557413391s
150 Total Events: 50000
151 Events/sec: 2036.05
152 Success Rate: 100.0%
153 Concurrent Workers: 24
154 Memory Used: 130 MB
155 Avg Latency: 385.432µs
156 P90 Latency: 801.624µs
157 P95 Latency: 897.528µs
158 P99 Latency: 1.136145ms
159 Bottom 10% Avg Latency: 1.031469ms
160 ----------------------------------------
161
162 Test: Query Performance
163 Duration: 1m0.004756071s
164 Total Events: 388544
165 Events/sec: 6475.22
166 Success Rate: 100.0%
167 Concurrent Workers: 24
168 Memory Used: 132 MB
169 Avg Latency: 1.723827ms
170 P90 Latency: 5.21331ms
171 P95 Latency: 6.917596ms
172 P99 Latency: 10.942489ms
173 Bottom 10% Avg Latency: 7.705115ms
174 ----------------------------------------
175
176 Test: Concurrent Query/Store
177 Duration: 1m0.003409818s
178 Total Events: 309051
179 Events/sec: 5150.56
180 Success Rate: 100.0%
181 Concurrent Workers: 24
182 Memory Used: 99 MB
183 Avg Latency: 1.532079ms
184 P90 Latency: 3.088572ms
185 P95 Latency: 4.004134ms
186 P99 Latency: 6.701092ms
187 Bottom 10% Avg Latency: 4.65921ms
188 ----------------------------------------
189
190 Report saved to: /tmp/benchmark_rely-sqlite_8/benchmark_report.txt
191 AsciiDoc report saved to: /tmp/benchmark_rely-sqlite_8/benchmark_report.adoc
192
193 RELAY_NAME: rely-sqlite
194 RELAY_URL: ws://rely-sqlite:3334
195 TEST_TIMESTAMP: 2025-11-22T19:10:18+00:00
196 BENCHMARK_CONFIG:
197 Events: 50000
198 Workers: 24
199 Duration: 60s
200