From mboxrd@z Thu Jan 1 00:00:00 1970 From: Peter =?utf-8?q?M=C3=BCller?= To: location@lists.ipfire.org Subject: [PATCH 7/8] location-importer.in: Create gist index for announcement table as well Date: Wed, 21 Oct 2020 14:47:42 +0000 Message-ID: <20201021144743.18083-7-peter.mueller@ipfire.org> In-Reply-To: <20201021144743.18083-1-peter.mueller@ipfire.org> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="===============2455430834812670796==" List-Id: --===============2455430834812670796== Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable This speeds up exporting the database as it avoits a sequential scan. Signed-off-by: Michael Tremer Signed-off-by: Peter M=C3=BCller --- src/python/location-importer.in | 1 + 1 file changed, 1 insertion(+) diff --git a/src/python/location-importer.in b/src/python/location-importer.in index 4f4a46d..9946e64 100644 --- a/src/python/location-importer.in +++ b/src/python/location-importer.in @@ -152,6 +152,7 @@ class CLI(object): last_seen_at timestamp without time zone DEFAULT CURRENT_TIMESTAMP); CREATE UNIQUE INDEX IF NOT EXISTS announcements_networks ON announcement= s(network); CREATE INDEX IF NOT EXISTS announcements_family ON announcements(family(= network)); + CREATE INDEX IF NOT EXISTS announcements_search ON announcements USING G= IST(network inet_ops); =20 -- autnums CREATE TABLE IF NOT EXISTS autnums(number bigint, name text NOT NULL); --=20 2.20.1 --===============2455430834812670796==--