[mapserver-users] Re: Mapserver 6 WMS / PostGIS Problem

[Rahkonen Jukka]

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-bounces at lists.osgeo.org 
> [mailto:mapserver-users-bounces at lists.osgeo.org] Puolesta anddreas2
> Lähetetty: 22. syyskuuta 2011 8:52
> Vastaanottaja: mapserver-users at 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 at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>