X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/984979d9bf448cf8dfab9be763c5e0ba6cf2f399..ab9202b1c2de078822756d447e450610f0815692:/docs/admin/Migration.md diff --git a/docs/admin/Migration.md b/docs/admin/Migration.md index 917d3785..b731c37c 100644 --- a/docs/admin/Migration.md +++ b/docs/admin/Migration.md @@ -24,6 +24,13 @@ You can then drop the old index with: DROP INDEX idx_placex_pendingsector ``` +### Unused index + +This index has been unused ever since the query using it was changed two years ago. Saves about 12GB on a planet installation. + +```sql +DROP INDEX idx_placex_geometry_reverse_lookupPoint +``` ### Switching to dotenv