diff mbox series

[06/10] importer: Use a GIST index for networks from geofeeds

Message ID 20220927164847.3409646-6-michael.tremer@ipfire.org
State Accepted
Commit 47fc42fb5f206c7fd9203876820c51b37e516b76
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 | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)
diff mbox series

Patch

diff --git a/src/scripts/location-importer.in b/src/scripts/location-importer.in
index f8d2dc8..5759e0c 100644
--- a/src/scripts/location-importer.in
+++ b/src/scripts/location-importer.in
@@ -207,7 +207,7 @@  class CLI(object):
 				CREATE INDEX IF NOT EXISTS geofeed_networks_geofeed_id
 					ON geofeed_networks(geofeed_id);
 				CREATE INDEX IF NOT EXISTS geofeed_networks_search
-					ON geofeed_networks(network);
+					ON geofeed_networks USING GIST(network inet_ops);
 				CREATE TABLE IF NOT EXISTS network_geofeeds(network inet, url text);
 				CREATE UNIQUE INDEX IF NOT EXISTS network_geofeeds_unique
 					ON network_geofeeds(network);