From mboxrd@z Thu Jan 1 00:00:00 1970 From: Michael Tremer To: location@lists.ipfire.org Subject: [PATCH 07/10] importer: Add a search index match geofeed networks quicker Date: Tue, 27 Sep 2022 16:48:44 +0000 Message-ID: <20220927164847.3409646-7-michael.tremer@ipfire.org> In-Reply-To: <20220927164847.3409646-1-michael.tremer@ipfire.org> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="===============4492566930152672698==" List-Id: --===============4492566930152672698== Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable Signed-off-by: Michael Tremer --- src/scripts/location-importer.in | 4 ++++ 1 file changed, 4 insertions(+) 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); =20 -- overrides CREATE TABLE IF NOT EXISTS autnum_overrides( --=20 2.30.2 --===============4492566930152672698==--