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"