view schema/README.md @ 4002:eb11ada33fa7

Avoid full sequential scans on some tables for every query Up to PostgreSQL 11, a CTE is always executed to completion, regardless of whether the result is actually needed for the calling query. A sub-select is not 'fenced' that way. Makes some database requests of GeoServer a lot faster.
author Tom Gottfried <tom@intevation.de>
date Thu, 18 Jul 2019 17:33:18 +0200
parents 85c47d63fdb9
children f2f0b776ba12
line wrap: on
line source

The gemma database schema requires PostgreSQL >= 11.

`dot.tmpl` is a template file for `postgresql_autodoc`
to be more similiar to UML and leave out some less useful labels.

See  `../docker/README.md`