From eeffe2caf46b4faed0531099d0b4b98502b1d43a Mon Sep 17 00:00:00 2001 From: marc tobias Date: Wed, 30 Sep 2020 14:28:20 +0200 Subject: [PATCH] migration guide: idx_placex_geometry_reverse_lookupPoint can be dropped --- docs/admin/Migration.md | 7 +++++++ 1 file changed, 7 insertions(+) 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 -- 2.39.5