If you turn the logging level up you will be able to see the actual query that GeoServer is running in the log file. Running explain on that may give more clues.
Ian On Mon, 25 Mar 2019 at 00:23, <wambac...@posteo.de> wrote: > Hi, > > i'm trying to compute centroids of clusters of geoms via a postgis query. > > something like this: > > select st_centroid(unnest(st_clusterwithin(geom,0.00045))) geom > from assoc3_house > > This query is used in a sql-layer (WFS) and gives reasonable results. :) > > BUT: the performance is very, very poor. Tablesize is about 460.000 nodes > and there is a spatial index on geom. *Runtime 3-4 minutes.* > > In PSQL the same query (of course with the corrisponding bbox) is running > in 2-3 seconds giving the same results. > > Any idea what is going on and what i can do? > > regards > > walter > -- > My projects: > > Admin Boundaries of the World <https://wambachers-osm.website/boundaries> > Missing Boundaries > <https://wambachers-osm.website/index.php/projekte/internationale-administrative-grenzen/missing-boundaries> > Emergency Map <https://wambachers-osm.website/emergency> > Postal Code Map (Germany only) <https://wambachers-osm.website/plz> > Fools (QA for zipcodes in Germany) <https://wambachers-osm.website/fools> > Postcode Boundaries of Germany > <https://wambachers-osm.website/pcoundaries> > _______________________________________________ > 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 > -- Ian Turton
_______________________________________________ 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
