Hi, Basically it means that the SQL query for getting the extents of your layer is slow. Set timing on with \timing on in your psql window and run query select st_extent(geom) from titles; http://postgis.refractions.net/docs/ST_Extent.html How long does it take? Do vacuum analyze for the table and try again to see if there has been some trouble with indexes. Anyway, it is always faster to get extents from the metadata line than from PostGIS, but normally it should not take very long. For me it takes 1500 ms with a table of 300000 polygons.
-Jukka Rahkonen- > -----Alkuperäinen viesti----- > Lähettäjä: mapserver-users-boun...@lists.osgeo.org > [mailto:mapserver-users-boun...@lists.osgeo.org] Puolesta anddreas2 > Lähetetty: 22. syyskuuta 2011 8:52 > Vastaanottaja: mapserver-users@lists.osgeo.org > Aihe: [mapserver-users] Re: Mapserver 6 WMS / PostGIS Problem > > I found the solution: > > Just set THE wms_extent METADATA in the layer section and it > works. Without > Layers wms_extent it crashes. > > (Jesus, I spent three days of my life for this stupid thing. > I tested with > all versions of postgis (1.5, 1.4) postgresql (8.4,9.0,9.1). > I am think it > is ms4w problem). > > -- > View this message in context: > http://osgeo-org.1803224.n2.nabble.com/Mapserver-6-WMS-PostGIS > -Problem-tp6387007p6819004.html > Sent from the Mapserver - User mailing list archive at Nabble.com. > _______________________________________________ > mapserver-users mailing list > mapserver-users@lists.osgeo.org > http://lists.osgeo.org/mailman/listinfo/mapserver-users > _______________________________________________ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
