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

Reply via email to