Slow WFS GetFeature when using a 3D bbox POST request

Description

When using the following configuration, a POST requests seems to result in Geoserver loading all features from database and performing the BBOX filter internally.

Environment:

  • Postgresql: "PostgreSQL 9.2.4, compiled by Visual C++ build 1600, 64-bit"

  • Postgis: "POSTGIS="2.0.3 r11132" GEOS="3.3.8-CAPI-1.7.8" PROJ="Rel. 4.8.0, 6 March 2012" GDAL="GDAL 1.9.2, released 2012/10/08" LIBXML="2.7.8" LIBJSON="UNKNOWN" RASTER"

  • Geoserver 2.9.1 and 2.10.1

  • JVM 1.8.0_112

Table creation:

POST request example:

According to the geoserver log file the following DB query is executed:

Environment

None

Assignee

Andrea Aime

Reporter

Andrea Aime

Triage

None

Fix versions

Affects versions

None

Priority

Medium
Configure