summaryrefslogtreecommitdiff
path: root/src/postprocess/postgres.sql
diff options
context:
space:
mode:
authorDirk Engling <erdgeist@erdgeist.org>2024-08-17 00:02:30 +0200
committerDirk Engling <erdgeist@erdgeist.org>2024-08-17 00:02:30 +0200
commitd56793d67824aa398cf20c22f708dda9ee5d1544 (patch)
treeb561b0ebf69b32897035b24c2fc294bf4fa4496a /src/postprocess/postgres.sql
parentd193694e3aa39ed135d399b4772e90b0cce027eb (diff)
Since phone books now are being spammed, limit the number of spam entries
Diffstat (limited to 'src/postprocess/postgres.sql')
-rw-r--r--src/postprocess/postgres.sql2
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
74CREATE INDEX idx_hausnummer ON table_hausnummer USING btree (value, telefonbuch_id, offs); 74CREATE INDEX idx_hausnummer ON table_hausnummer USING btree (value, telefonbuch_id, offs);
75CREATE INDEX idx_zip ON table_zip USING btree (value, telefonbuch_id, offs); 75CREATE INDEX idx_zip ON table_zip USING btree (value, telefonbuch_id, offs);
76CREATE INDEX idx_ort ON table_ort USING btree (value, telefonbuch_id, offs); 76CREATE INDEX idx_ort ON table_ort USING btree (value, telefonbuch_id, offs);
77CREATE INDEX idx_verweise ON table_verweise USING btree (value, telefonbuch_id, offs); 77CREATE INDEX idx_verweise ON table_verweise USING btree (value, telefonbuch_id, offs) WHERE LENGTH(value) < 256;
78CREATE INDEX idx_vorwahl ON table_vorwahl USING btree (value, telefonbuch_id, offs); 78CREATE INDEX idx_vorwahl ON table_vorwahl USING btree (value, telefonbuch_id, offs);
79CREATE INDEX idx_rufnummer ON table_rufnummer USING btree (value, telefonbuch_id, offs); 79CREATE INDEX idx_rufnummer ON table_rufnummer USING btree (value, telefonbuch_id, offs);
80CREATE INDEX idx_web ON table_web USING btree (value, telefonbuch_id, offs); 80CREATE INDEX idx_web ON table_web USING btree (value, telefonbuch_id, offs);