Mercurial > gemma
comparison schema/default_sysconfig.sql @ 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 | f1ce295d9283 |
children | c56db74e2f9b |
comparison
equal
deleted
inserted
replaced
4001:bf86f9a08733 | 4002:eb11ada33fa7 |
---|