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 1764142450497543ℹ️ migrating to version 1... /build/pkg/database/migrations.go:66
5 1764142450497609ℹ️ migrating to version 2... /build/pkg/database/migrations.go:73
6 1764142450497631ℹ️ migrating to version 3... /build/pkg/database/migrations.go:80
7 1764142450497636ℹ️ cleaning up ephemeral events (kinds 20000-29999)... /build/pkg/database/migrations.go:294
8 1764142450497646ℹ️ cleaned up 0 ephemeral events from database /build/pkg/database/migrations.go:339
9 1764142450497688ℹ️ migrating to version 4... /build/pkg/database/migrations.go:87
10 1764142450497694ℹ️ converting events to optimized inline storage (Reiser4 optimization)... /build/pkg/database/migrations.go:347
11 1764142450497706ℹ️ found 0 events to convert (0 regular, 0 replaceable, 0 addressable) /build/pkg/database/migrations.go:436
12 1764142450497711ℹ️ migration complete: converted 0 events to optimized inline storage, deleted 0 old keys /build/pkg/database/migrations.go:545
13 1764142450497773ℹ️ migrating to version 5... /build/pkg/database/migrations.go:94
14 1764142450497779ℹ️ re-encoding events with optimized tag binary format... /build/pkg/database/migrations.go:552
15 1764142450497793ℹ️ found 0 events with e/p tags to re-encode /build/pkg/database/migrations.go:639
16 1764142450497798ℹ️ 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/26 07:34:10 INFO: Extracted embedded libsecp256k1 to /tmp/orly-libsecp256k1/libsecp256k1.so
27 2025/11/26 07:34:10 INFO: Successfully loaded embedded libsecp256k1 v5.0.0 from /tmp/orly-libsecp256k1/libsecp256k1.so
28 Events saved: 50000/50000 (100.0%), errors: 0
29 Duration: 3.067785126s
30 Events/sec: 16298.40
31 Avg latency: 1.360569ms
32 P90 latency: 1.819407ms
33 P95 latency: 2.160818ms
34 P99 latency: 3.606363ms
35 Bottom 10% Avg latency: 746.704µs
36 Wiping database between tests...
37 RunBurstPatternTest (Badger)..
38
39 === Burst Pattern Test ===
40 Burst completed: 5000 events in 312.311304ms
41 Burst completed: 5000 events in 359.334028ms
42 Burst completed: 5000 events in 307.257652ms
43 Burst completed: 5000 events in 318.240243ms
44 Burst completed: 5000 events in 295.405906ms
45 Burst completed: 5000 events in 369.690986ms
46 Burst completed: 5000 events in 308.42646ms
47 Burst completed: 5000 events in 267.313308ms
48 Burst completed: 5000 events in 301.834829ms
49 Burst completed: 5000 events in 282.800373ms
50 Burst test completed: 50000 events in 8.128805288s, errors: 0
51 Events/sec: 6150.97
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.426575006s
70 Combined ops/sec: 2046.95
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: 369377 queries in 1m0.005034278s
83 Queries/sec: 6155.77
84 Avg query latency: 1.850212ms
85 P95 query latency: 7.621476ms
86 P99 query latency: 11.610958ms
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: 310678 operations (260678 queries, 50000 writes) in 1m0.003278222s
105 Operations/sec: 5177.68
106 Avg latency: 1.513088ms
107 Avg query latency: 1.495086ms
108 Avg write latency: 1.606937ms
109 P95 latency: 3.92433ms
110 P99 latency: 6.216487ms
111
112 === Badger benchmark completed ===
113
114
115 ================================================================================
116 BENCHMARK REPORT
117 ================================================================================
118
119 Test: Peak Throughput
120 Duration: 3.067785126s
121 Total Events: 50000
122 Events/sec: 16298.40
123 Success Rate: 100.0%
124 Concurrent Workers: 24
125 Memory Used: 89 MB
126 Avg Latency: 1.360569ms
127 P90 Latency: 1.819407ms
128 P95 Latency: 2.160818ms
129 P99 Latency: 3.606363ms
130 Bottom 10% Avg Latency: 746.704µs
131 ----------------------------------------
132
133 Test: Burst Pattern
134 Duration: 8.128805288s
135 Total Events: 50000
136 Events/sec: 6150.97
137 Success Rate: 100.0%
138 Concurrent Workers: 24
139 Memory Used: 203 MB
140 Avg Latency: 1.411735ms
141 P90 Latency: 1.9936ms
142 P95 Latency: 2.29313ms
143 P99 Latency: 3.168238ms
144 Bottom 10% Avg Latency: 711.036µs
145 ----------------------------------------
146
147 Test: Mixed Read/Write
148 Duration: 24.426575006s
149 Total Events: 50000
150 Events/sec: 2046.95
151 Success Rate: 100.0%
152 Concurrent Workers: 24
153 Memory Used: 127 MB
154 Avg Latency: 401.18µs
155 P90 Latency: 826.125µs
156 P95 Latency: 916.446µs
157 P99 Latency: 1.122669ms
158 Bottom 10% Avg Latency: 1.080638ms
159 ----------------------------------------
160
161 Test: Query Performance
162 Duration: 1m0.005034278s
163 Total Events: 369377
164 Events/sec: 6155.77
165 Success Rate: 100.0%
166 Concurrent Workers: 24
167 Memory Used: 106 MB
168 Avg Latency: 1.850212ms
169 P90 Latency: 5.767292ms
170 P95 Latency: 7.621476ms
171 P99 Latency: 11.610958ms
172 Bottom 10% Avg Latency: 8.365982ms
173 ----------------------------------------
174
175 Test: Concurrent Query/Store
176 Duration: 1m0.003278222s
177 Total Events: 310678
178 Events/sec: 5177.68
179 Success Rate: 100.0%
180 Concurrent Workers: 24
181 Memory Used: 133 MB
182 Avg Latency: 1.513088ms
183 P90 Latency: 3.049471ms
184 P95 Latency: 3.92433ms
185 P99 Latency: 6.216487ms
186 Bottom 10% Avg Latency: 4.456235ms
187 ----------------------------------------
188
189 Report saved to: /tmp/benchmark_rely-sqlite_8/benchmark_report.txt
190 AsciiDoc report saved to: /tmp/benchmark_rely-sqlite_8/benchmark_report.adoc
191
192 RELAY_NAME: rely-sqlite
193 RELAY_URL: ws://rely-sqlite:3334
194 TEST_TIMESTAMP: 2025-11-26T07:37:28+00:00
195 BENCHMARK_CONFIG:
196 Events: 50000
197 Workers: 24
198 Duration: 60s
199