changeset 1209:df75a467d55a

Add spatial index to speed up OrtFactory.findVerwaltungseinheit().
author Tom Gottfried <tom@intevation.de>
date Mon, 05 Dec 2016 12:28:59 +0100 (2016-12-05)
parents 9dda1237c756
children b22ffbf88a43
files db_schema/stammdaten_schema.sql
diffstat 1 files changed, 1 insertions(+), 0 deletions(-) [+]
line wrap: on
line diff
--- a/db_schema/stammdaten_schema.sql	Mon Dec 05 12:20:10 2016 +0100
+++ b/db_schema/stammdaten_schema.sql	Mon Dec 05 12:28:59 2016 +0100
@@ -169,6 +169,7 @@
     gem_id character varying(8) NOT NULL REFERENCES verwaltungseinheit,
     shape public.geometry(MultiPolygon, 4326)
 );
+CREATE INDEX verwaltungsgrenze_sp_idx ON verwaltungsgrenze USING gist (shape);
 
 CREATE TABLE netz_betreiber (
     id character varying(2) PRIMARY KEY,
This site is hosted by Intevation GmbH (Datenschutzerklärung und Impressum | Privacy Policy and Imprint)