Files
beacon-server/db/migrations/002_known_routes_node_ids_gin.sql
MrAlders0n 9bbf8efee5 release: v2.0.4 (#217)
* perf(routes): batch cross-IATA and hash route search (#216)

One search fired a /routes/cross request per IATA pair (138k on 2026-10-08). Route search now takes an optional iatas list and runs a fixed number of index-backed queries. /info advertises built-in minimum client versions.

* chore: bump version to 2.0.4
2026-10-09 22:17:23 -04:00

6 lines
234 B
SQL

-- Copyright 2026 Beacon Contributors
-- SPDX-License-Identifier: AGPL-3.0-or-later
-- Cross-IATA route search looks routes up by member node.
CREATE INDEX CONCURRENTLY idx_known_routes_node_ids ON known_routes USING gin (node_ids);