From 927b4c928e4e54fd185c08b9c8b486340a085122 Mon Sep 17 00:00:00 2001 From: Sarah Hoffmann Date: Wed, 10 Jul 2019 22:51:15 +0200 Subject: [PATCH] add migration hints for country table --- docs/admin/Migration.md | 16 ++++++++++++++++ 1 file changed, 16 insertions(+) diff --git a/docs/admin/Migration.md b/docs/admin/Migration.md index ebad9c48..c5a05d9a 100644 --- a/docs/admin/Migration.md +++ b/docs/admin/Migration.md @@ -6,6 +6,22 @@ to newer versions of Nominatim. SQL statements should be executed from the PostgreSQL commandline. Execute `psql nominatim` to enter command line mode. +## 3.3.0 -> master + +### Reorganisation of location_area_country table + +The table `location_area_country` has been optimized. You need to switch to the +new format when you run updates. While updates are disabled, run the following +SQL commands: + +```sql +CREATE TABLE location_area_country_new AS + SELECT place_id, country_code, geometry FROM location_area_country; +DROP TABLE location_area_country; +ALTER TABLE location_area_country_new RENAME TO location_area_country; +CREATE INDEX idx_location_area_country_geometry ON location_area_country USING GIST (geometry); +CREATE INDEX idx_location_area_country_place_id ON location_area_country USING BTREE (place_id); +``` ## 3.2.0 -> 3.3.0 -- 2.39.5