Mercurial > gemma
diff example_conf.toml @ 4624:209b10f7bb2c geoserver_sql_views
Add config for GeoServer database session startup SQL
Prepended to setting the role in order to avoid any configuration
overwriting it.
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Wed, 09 Oct 2019 18:47:13 +0200 |
parents | 317d176ef38c |
children | 492fc5870330 |
line wrap: on
line diff
--- a/example_conf.toml Wed Oct 09 16:40:18 2019 +0200 +++ b/example_conf.toml Wed Oct 09 18:47:13 2019 +0200 @@ -56,6 +56,17 @@ # an explicit --geoserver-clean on the command line. #geoserver-clean = true +# geoserver-startup-sql can be used to add SQL commands to GeoServers database +# session start script. See +# https://docs.geoserver.org/stable/en/user/data/database/sqlsession.html +# Note that the commands will be executed as the user configured as 'db-user'. +# This can be used for example to set query planer configurations that fix +# bad query plans during GeoServer accessing the published layers. +# Currently, the published layer 'bottlenecks_geoserver' is known to trigger +# inefficient nested loop joins due to underestimation of the number of entries +# in the bottlenecks table. Hence the example setting: +geoserver-startup-sql = "SET enable_nestloop TO off" + # Proxy settings for external OGC services #proxy-key = "SECRET" #proxy-prefix = "http://localhost:8000"