Hi, Is the spatial index OK? There is the && bounding box query happening too, not just "select geometry from my_table".
-Jukka Rahkonen- ________________________________ Lähettäjä: [email protected] [[email protected]] käyttäjän G. Allegri [[email protected]] puolesta Lähetetty: 28. kesäkuuta 2012 1:53 Vastaanottaja: [email protected] Aihe: [mapserver-users] slow access to PostGIS layer [cross posting from MS4W ml] I'm working on a Windows 7 machine with PostGIS 1.5 on Postgresql 8.4, with no tuning (default configuration). I'm facing very bad performances when accessing a polygonal layer on PostGIS. The layer is not that heavy and complex. It is made by 20 polygons with about 4000 to 56000 vertices. The raw query (SELECT the_geom FROM mytable), performed through the psql console, fetches the results in about 185 ms. Logging the layer with DEBUG 5 shows that iterating over the features takes about 7.5 s. The time between consecutive msPostGISLayerNextShape calls is about 0.3/0.4 s. Here is the log file: http://www.giovanniallegri.it/share/mspglog.txt I obtain the same performances with ms4w 3.0.6(MapServer MapScript to 6.0.3) and 3.0.4_dev (MapServer and MapScript 6.1-dev), which PostGIS is 1.5 on Postgresql 8.4, with no customized options. I'm working on a Windows 7 machine, but the work should be deployed on a Windows Server 2003. I'm not using connection pooling, but I was facing similar performances before disabling it. giovanni _______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
