diff mbox series

[07/10] importer: Add a search index match geofeed networks quicker

Message ID 20220927164847.3409646-7-michael.tremer@ipfire.org
State Accepted
Commit 7f0a6add0e7f0af60250bb2c1a676b229263da8f
Headers
Series [01/10] importer: Store geofeed URLs from RIR data |

Commit Message

Michael Tremer Sept. 27, 2022, 4:48 p.m. UTC 
  Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
---
 src/scripts/location-importer.in | 4 ++++
 1 file changed, 4 insertions(+)
diff mbox series

Patch

diff --git a/src/scripts/location-importer.in b/src/scripts/location-importer.in
index 5759e0c..7e2136e 100644
--- a/src/scripts/location-importer.in
+++ b/src/scripts/location-importer.in
@@ -211,6 +211,10 @@  class CLI(object):
 				CREATE TABLE IF NOT EXISTS network_geofeeds(network inet, url text);
 				CREATE UNIQUE INDEX IF NOT EXISTS network_geofeeds_unique
 					ON network_geofeeds(network);
+				CREATE INDEX IF NOT EXISTS network_geofeeds_search
+					ON network_geofeeds USING GIST(network inet_ops);
+				CREATE INDEX IF NOT EXISTS network_geofeeds_url
+					ON network_geofeeds(url);
 
 				-- overrides
 				CREATE TABLE IF NOT EXISTS autnum_overrides(