From d56793d67824aa398cf20c22f708dda9ee5d1544 Mon Sep 17 00:00:00 2001 From: Dirk Engling 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(-) 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