Hello,
We are using the Vector Mosaic datastore
(https://docs.geoserver.org/main/en/user/community/vector-mosaic/index.html).
It seems to functioning well for our needs except for one case.
With a WFS GetFeature request, the response time is so slow our load balancer
times out before the response comes back grom GeoServer. The timeout is 1 min,
a typical WFS GetFeature request takes about 2 mins according to the GeoServer
logs.
Our mosaic index is stored in PostgreSQL and the mosaic flat files are
FlatGeoBuf.
>From the GeoServer logs, it appears that the entire index is being queried
>instead of being filtered by the input bounding box to the GetFeature. We have
>over 1000 rows in the index. I am guessing each of these files are then being
>queried against the bounding box, but I'm not sure.
It starts with this query:
SELECT "ogc_fid",encode(ST_AsEWKB("wkb_geometry"), 'base64') as
"wkb_geometry","params" FROM "vector_products"."raw_points_index";
Then we get many entries like:
[geotools.vectormosaic] - Found and set datastore for granule null with params
{url=file:/
/GeoserverData/farmtrx/raw_points/dALzgubWabg8nVZlObJZU_raw_points_32814/dALzgubWabg8nVZlObJZU_raw_points_32814.fgb}
Eventually it seems to succeed, but long after the gateway timed out:
"GET
/geoserver/wfs?service=WFS&version=2.0.0&request=GetFeature&outputFormat=application/json&bbox=-8428045.938524414,5672717.233576572,-8427400.045285502,5673091.775131803,EPSG:3857&typeName=raw_points&SLD=file:///
/styles/abXuSt4KMlbFn8SG84bHX/abXuSt4KMlbFn8SG84bHX_33272_raw_points_hct.sld&count=100&propertyName=yldt_ha"
took 119988ms
Previously we stored all the vector data in PostgreSQL and this GetFeature
query returned nearly instantaneously. Am I correct that it seems the original
query would be better to be filtered by the bounding box, thus returning one or
a few rows?
Thanks,
Richard
_______________________________________________
Geoserver-users mailing list
Please make sure you read the following two resources before posting to this
list:
- Earning your support instead of buying it, but Ian Turton:
http://www.ianturton.com/talks/foss4g.html#/
- The GeoServer user list posting guidelines:
http://geoserver.org/comm/userlist-guidelines.html
If you want to request a feature or an improvement, also see this:
https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
