Mercurial > gemma
view client/public/img/gemma-logo-for-pdf.png @ 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 | bafe68178528 |
| children |
