From: Sarah Hoffmann Date: Sat, 10 Mar 2012 13:14:33 +0000 (+0100) Subject: put indexing in update mode X-Git-Tag: deploy~709 X-Git-Url: https://git.openstreetmap.org./nominatim.git/commitdiff_plain/28ad09a20aa81c3ac1f5c50db4e9954057b4142c?hp=a038582e34d73ac2575572c9dec0e890557fb0f5 put indexing in update mode --- diff --git a/sql/functions.sql b/sql/functions.sql index 6ad13892..84046d7e 100644 --- a/sql/functions.sql +++ b/sql/functions.sql @@ -1108,7 +1108,7 @@ BEGIN -- RETURN NULL; -- END IF; - RETURN NEW; -- The following is not needed until doing diff updates, and slows the main index process down +-- RETURN NEW; -- The following is not needed until doing diff updates, and slows the main index process down IF (ST_GeometryType(NEW.geometry) in ('ST_Polygon','ST_MultiPolygon') AND ST_IsValid(NEW.geometry)) THEN -- Performance: We just can't handle re-indexing for country level changes