[mapserver-users] PostGIS date queries performance issues

[Lime, Steve D (MNIT)]

Tom: There were definitely changes in this area. Can you share the WFS filter plus the resulting SQL in each version. This is the type of thing that should have gotten better in 7.0 as WFS filters are translated more completely into native SQL. It’s possible I introduced an inefficiency in that translation beyond what was done for PostGIS in mapogcfilter.c in 6.4.  -Steve

-----Original Message-----
From: mapserver-users [mailto:mapserver-users-bounces at lists.osgeo.org] On Behalf Of Kralidis, Tom (EC)
Sent: Thursday, November 17, 2016 8:14 PM
To: mapserver-users at lists.osgeo.org
Subject: [mapserver-users] PostGIS date queries performance issues

Hi all: using 7.0.2 against a PostgreSQL 9.3/PostGIS 2.2 instance we're getting very long (timeouts even) response times when doing WFS filters against PostgreSQL date types.

I've posted a Gist at [1] to help in reporting.  Note that this functionality used to work with acceptable performance in 6.4.x.

Looking deeper (see Gist) it appears that the SQL queries that MapServer crafts for PostgreSQL are different.  When I try the 7.0.2 based SQL in a psql prompt, the same very long response time results.

Any idea what could be going on here?

Thanks

..Tom

[1] https://gist.github.com/tomkralidis/006594382d6339c2047b441108a3991b
_______________________________________________
mapserver-users mailing list
mapserver-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users