Since phone books now are being spammed, limit the number of spam entries

1 files changed, 1 insertions, 1 deletions

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);