On Fri, Feb 11, 2011 at 12:35 PM, Milo van der Linden <[email protected]> wrote: > This may have to do with the geotools regex (java.util.regex) doesn't > translate to postgresql's internal regex > http://www.postgresql.org/docs/8.1/static/functions-matching.html > > Can you capture the queries sent by geoserver to the postgis database on > requesting the labels? > > If it turns out to indeed be an issue, maybe geotools should be altered > instead of geoserver?
I'm pretty sure the regex won't be translated down to sql (no function call is), however that should mean GeoServer loads all the data in the current viewing area and then runs the regex on top of the returned data in memory to further trim it down. However, you say it's not working some maybe something is not working with the in memory post-filtering... So I've quickly imported poly_landmarks into postgis (under a different name, pg_plandmark, to make sure I don't confuse the two) and repeated the filtering with ECQL, which appears to be working just fine. Also tried with a SLD style and a CQL filter on a WFS request, they both do work fine for me as well. Soo... at the very least I cannot reproduce the issue here Cheers Andrea -- ------------------------------------------------------- Ing. Andrea Aime GeoSolutions S.A.S. Tech lead Via Poggio alle Viti 1187 55054 Massarosa (LU) Italy phone: +39 0584 962313 fax: +39 0584 962313 mob: +39 333 8128928 http://www.geo-solutions.it http://geo-solutions.blogspot.com/ http://www.youtube.com/user/GeoSolutionsIT http://www.linkedin.com/in/andreaaime http://twitter.com/geowolf ------------------------------------------------------- ------------------------------------------------------------------------------ The ultimate all-in-one performance toolkit: Intel(R) Parallel Studio XE: Pinpoint memory and threading errors before they happen. Find and fix more than 250 security defects in the development cycle. Locate bottlenecks in serial and parallel code that limit performance. http://p.sf.net/sfu/intel-dev2devfeb _______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
