[mapserver-users] PostGIS date queries performance issues

[Kralidis, Tom (EC)]

Steve: info can be found at https://gist.github.com/tomkralidis/006594382d6339c2047b441108a3991b



> -----Original Message-----
> From: Lime, Steve D (MNIT) [mailto:Steve.Lime at state.mn.us]
> Sent: 18 November 2016 13:10
> To: Kralidis, Tom (EC); mapserver-users at lists.osgeo.org
> Subject: RE: PostGIS date queries performance issues
> 
> 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