From d56793d67824aa398cf20c22f708dda9ee5d1544 Mon Sep 17 00:00:00 2001
From: Dirk Engling <erdgeist@erdgeist.org>
Date: Sat, 17 Aug 2024 00:02:30 +0200
Subject: Since phone books now are being spammed, limit the number of spam
 entries

---
 src/postprocess/postgres.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'src/postprocess/postgres.sql')

diff --git a/src/postprocess/postgres.sql b/src/postprocess/postgres.sql
index 2d89d1c..3c891d4 100644
--- a/src/postprocess/postgres.sql
+++ b/src/postprocess/postgres.sql
@@ -74,7 +74,7 @@ CREATE INDEX idx_strasse    ON  table_strasse    USING btree (value, telefonbuch
 CREATE INDEX idx_hausnummer ON  table_hausnummer USING btree (value, telefonbuch_id, offs);
 CREATE INDEX idx_zip        ON  table_zip        USING btree (value, telefonbuch_id, offs);
 CREATE INDEX idx_ort        ON  table_ort        USING btree (value, telefonbuch_id, offs);
-CREATE INDEX idx_verweise   ON  table_verweise   USING btree (value, telefonbuch_id, offs);
+CREATE INDEX idx_verweise   ON  table_verweise   USING btree (value, telefonbuch_id, offs) WHERE LENGTH(value) < 256;
 CREATE INDEX idx_vorwahl    ON  table_vorwahl    USING btree (value, telefonbuch_id, offs);
 CREATE INDEX idx_rufnummer  ON  table_rufnummer  USING btree (value, telefonbuch_id, offs);
 CREATE INDEX idx_web        ON  table_web        USING btree (value, telefonbuch_id, offs);
-- 
cgit v1.2.3

