Mercurial > gemma
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`