Mercurial > gemma
view .hgchurn @ 4016:9ab7e1056360
Optimize index setup a bit
Optimize column order in multi-column indexes created automatically
for constraints in order to match access patterns better. This
makes the extra indexes on measure_date obsolete.
Add a further index for fast retrieval of newest measurement
per location, which is currently needed in some VIEWs for GeoServer.
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Fri, 19 Jul 2019 14:30:14 +0200 |
parents | 451c7d3fe6be |
children |
line wrap: on
line source
teichmann@intevation.de = sascha.teichmann@intevation.de bernhard.reiter@intevation.de = bernhard@intevation.de