diff options
-rw-r--r-- | src/postprocess/postgres.sql | 2 |
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 | |||
74 | CREATE INDEX idx_hausnummer ON table_hausnummer USING btree (value, telefonbuch_id, offs); | 74 | CREATE INDEX idx_hausnummer ON table_hausnummer USING btree (value, telefonbuch_id, offs); |
75 | CREATE INDEX idx_zip ON table_zip USING btree (value, telefonbuch_id, offs); | 75 | CREATE INDEX idx_zip ON table_zip USING btree (value, telefonbuch_id, offs); |
76 | CREATE INDEX idx_ort ON table_ort USING btree (value, telefonbuch_id, offs); | 76 | CREATE INDEX idx_ort ON table_ort USING btree (value, telefonbuch_id, offs); |
77 | CREATE INDEX idx_verweise ON table_verweise USING btree (value, telefonbuch_id, offs); | 77 | CREATE INDEX idx_verweise ON table_verweise USING btree (value, telefonbuch_id, offs) WHERE LENGTH(value) < 256; |
78 | CREATE INDEX idx_vorwahl ON table_vorwahl USING btree (value, telefonbuch_id, offs); | 78 | CREATE INDEX idx_vorwahl ON table_vorwahl USING btree (value, telefonbuch_id, offs); |
79 | CREATE INDEX idx_rufnummer ON table_rufnummer USING btree (value, telefonbuch_id, offs); | 79 | CREATE INDEX idx_rufnummer ON table_rufnummer USING btree (value, telefonbuch_id, offs); |
80 | CREATE INDEX idx_web ON table_web USING btree (value, telefonbuch_id, offs); | 80 | CREATE INDEX idx_web ON table_web USING btree (value, telefonbuch_id, offs); |