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 1764800424570824ℹ️ migrating to version 1... /build/pkg/database/migrations.go:68
5 1764800424571528ℹ️ migrating to version 2... /build/pkg/database/migrations.go:75
6 1764800424571758ℹ️ migrating to version 3... /build/pkg/database/migrations.go:82
7 1764800424571773ℹ️ cleaning up ephemeral events (kinds 20000-29999)... /build/pkg/database/migrations.go:304
8 1764800424571799ℹ️ cleaned up 0 ephemeral events from database /build/pkg/database/migrations.go:349
9 1764800424571834ℹ️ migrating to version 4... /build/pkg/database/migrations.go:89
10 1764800424571844ℹ️ converting events to optimized inline storage (Reiser4 optimization)... /build/pkg/database/migrations.go:357
11 1764800424571863ℹ️ found 0 events to convert (0 regular, 0 replaceable, 0 addressable) /build/pkg/database/migrations.go:446
12 1764800424571878ℹ️ migration complete: converted 0 events to optimized inline storage, deleted 0 old keys /build/pkg/database/migrations.go:555
13 1764800424571916ℹ️ migrating to version 5... /build/pkg/database/migrations.go:96
14 1764800424571927ℹ️ re-encoding events with optimized tag binary format... /build/pkg/database/migrations.go:562
15 1764800424571949ℹ️ found 0 events with e/p tags to re-encode /build/pkg/database/migrations.go:649
16 1764800424571958ℹ️ no events need re-encoding /build/pkg/database/migrations.go:652
17 1764800424571993ℹ️ migrating to version 6... /build/pkg/database/migrations.go:103
18 1764800424572004ℹ️ converting events to compact serial-reference format... /build/pkg/database/migrations.go:706
19 1764800424572070ℹ️ found 0 events to convert to compact format /build/pkg/database/migrations.go:846
20 1764800424572082ℹ️ 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:20:24 INFO: Extracted embedded libsecp256k1 to /tmp/orly-libsecp256k1/libsecp256k1.so
31 2025/12/03 22:20:24 INFO: Successfully loaded embedded libsecp256k1 v5.0.0 from /tmp/orly-libsecp256k1/libsecp256k1.so
32 Events saved: 50000/50000 (100.0%), errors: 0
33 Duration: 2.995055353s
34 Events/sec: 16694.18
35 Avg latency: 1.339216ms
36 P90 latency: 1.68929ms
37 P95 latency: 1.894111ms
38 P99 latency: 3.956722ms
39 Bottom 10% Avg latency: 779.552µs
40 Wiping database between tests...
41 RunBurstPatternTest (Badger)..
42
43 === Burst Pattern Test ===
44 Burst completed: 5000 events in 287.657346ms
45 Burst completed: 5000 events in 297.188663ms
46 Burst completed: 5000 events in 367.265309ms
47 Burst completed: 5000 events in 331.9274ms
48 Burst completed: 5000 events in 304.066462ms
49 Burst completed: 5000 events in 310.832609ms
50 Burst completed: 5000 events in 268.076751ms
51 Burst completed: 5000 events in 264.808751ms
52 Burst completed: 5000 events in 267.153131ms
53 Burst completed: 5000 events in 269.523097ms
54 Burst test completed: 50000 events in 7.973932498s, errors: 0
55 Events/sec: 6270.43
56 Wiping database between tests...
57 RunMixedReadWriteTest (Badger)..
58
59 === Mixed Read/Write Test ===
60 Generating 1000 unique synthetic events (minimum 300 bytes each)...
61 Generated 1000 events:
62 Average content size: 312 bytes
63 All events are unique (incremental timestamps)
64 All events are properly signed
65
66 Pre-populating database for read tests...
67 Generating 50000 unique synthetic events (minimum 300 bytes each)...
68 Generated 50000 events:
69 Average content size: 314 bytes
70 All events are unique (incremental timestamps)
71 All events are properly signed
72
73 Mixed test completed: 25000 writes, 25000 reads in 24.337287687s
74 Combined ops/sec: 2054.46
75 Wiping database between tests...
76 RunQueryTest (Badger)..
77
78 === Query Test ===
79 Generating 10000 unique synthetic events (minimum 300 bytes each)...
80 Generated 10000 events:
81 Average content size: 313 bytes
82 All events are unique (incremental timestamps)
83 All events are properly signed
84
85 Pre-populating database with 10000 events for query tests...
86 Query test completed: 406493 queries in 1m0.003860956s
87 Queries/sec: 6774.45
88 Avg query latency: 2.248129ms
89 P95 query latency: 8.401333ms
90 P99 query latency: 12.724368ms
91 Wiping database between tests...
92 RunConcurrentQueryStoreTest (Badger)..
93
94 === Concurrent Query/Store Test ===
95 Generating 5000 unique synthetic events (minimum 300 bytes each)...
96 Generated 5000 events:
97 Average content size: 313 bytes
98 All events are unique (incremental timestamps)
99 All events are properly signed
100
101 Pre-populating database with 5000 events for concurrent query/store test...
102 Generating 50000 unique synthetic events (minimum 300 bytes each)...
103 Generated 50000 events:
104 Average content size: 314 bytes
105 All events are unique (incremental timestamps)
106 All events are properly signed
107
108 Concurrent test completed: 318750 operations (268750 queries, 50000 writes) in 1m0.003885697s
109 Operations/sec: 5312.16
110 Avg latency: 1.416974ms
111 Avg query latency: 1.494262ms
112 Avg write latency: 1.001551ms
113 P95 latency: 3.592498ms
114 P99 latency: 8.935176ms
115
116 === Badger benchmark completed ===
117
118
119 ================================================================================
120 BENCHMARK REPORT
121 ================================================================================
122
123 Test: Peak Throughput
124 Duration: 2.995055353s
125 Total Events: 50000
126 Events/sec: 16694.18
127 Success Rate: 100.0%
128 Concurrent Workers: 24
129 Memory Used: 168 MB
130 Avg Latency: 1.339216ms
131 P90 Latency: 1.68929ms
132 P95 Latency: 1.894111ms
133 P99 Latency: 3.956722ms
134 Bottom 10% Avg Latency: 779.552µs
135 ----------------------------------------
136
137 Test: Burst Pattern
138 Duration: 7.973932498s
139 Total Events: 50000
140 Events/sec: 6270.43
141 Success Rate: 100.0%
142 Concurrent Workers: 24
143 Memory Used: 200 MB
144 Avg Latency: 1.281976ms
145 P90 Latency: 1.779141ms
146 P95 Latency: 2.087148ms
147 P99 Latency: 3.70878ms
148 Bottom 10% Avg Latency: 616.517µs
149 ----------------------------------------
150
151 Test: Mixed Read/Write
152 Duration: 24.337287687s
153 Total Events: 50000
154 Events/sec: 2054.46
155 Success Rate: 100.0%
156 Concurrent Workers: 24
157 Memory Used: 167 MB
158 Avg Latency: 393.526µs
159 P90 Latency: 818.886µs
160 P95 Latency: 910.529µs
161 P99 Latency: 1.137331ms
162 Bottom 10% Avg Latency: 1.057702ms
163 ----------------------------------------
164
165 Test: Query Performance
166 Duration: 1m0.003860956s
167 Total Events: 406493
168 Events/sec: 6774.45
169 Success Rate: 100.0%
170 Concurrent Workers: 24
171 Memory Used: 218 MB
172 Avg Latency: 2.248129ms
173 P90 Latency: 6.801515ms
174 P95 Latency: 8.401333ms
175 P99 Latency: 12.724368ms
176 Bottom 10% Avg Latency: 9.254973ms
177 ----------------------------------------
178
179 Test: Concurrent Query/Store
180 Duration: 1m0.003885697s
181 Total Events: 318750
182 Events/sec: 5312.16
183 Success Rate: 100.0%
184 Concurrent Workers: 24
185 Memory Used: 145 MB
186 Avg Latency: 1.416974ms
187 P90 Latency: 2.911313ms
188 P95 Latency: 3.592498ms
189 P99 Latency: 8.935176ms
190 Bottom 10% Avg Latency: 5.052685ms
191 ----------------------------------------
192
193 Report saved to: /tmp/benchmark_rely-sqlite_8/benchmark_report.txt
194 AsciiDoc report saved to: /tmp/benchmark_rely-sqlite_8/benchmark_report.adoc
195
196 RELAY_NAME: rely-sqlite
197 RELAY_URL: ws://rely-sqlite:3334
198 TEST_TIMESTAMP: 2025-12-03T22:23:41+00:00
199 BENCHMARK_CONFIG:
200 Events: 50000
201 Workers: 24
202 Duration: 60s
203