Re: Σχετ: [mapserver-users] Re: Mapserver 6 WMS / PostGIS Problem

[thomas bonfort]

When the request hangs, is it the mapserver process or the postgres
one that is eating all the cpu cycles ?

--
thomas

2011/9/22 Rahkonen Jukka <Jukka.Rahkonen at mmmtike.fi>:
> Hi,
>
> I can repeat this problem with Mapserver 6.0.1 on Windows Vista 32-bit.  I
> defined one PostGIS test layer without metadata and GetCapabilities fails
> after a long waiting. With DEBUG 5 the last line in MS_ERRORFILE that
> appears is this
> msPostGISLayerIsOpen called.
>
> Adding "wms_extent" corrects the situation.  Same mapfile does work on Linux
> and it used to work for me on Windows too with Mapserver 5.x.
>
> -Jukka Rahkonen-
>
> ________________________________
> Lähettäjä: Andreas Douvalis [mailto:anddreas2 at yahoo.gr]
> Lähetetty: 22. syyskuuta 2011 10:14
> Vastaanottaja: Rahkonen Jukka
> Aihe: Σχετ: [mapserver-users] Re: Mapserver 6 WMS / PostGIS Problem
>
> No problem with pgsql
> <!--[if !supportLineBreakNewLine]-->
> <!--[endif]-->
> It takes 78 ms the sql of the layer that it doesn't work with wms get map
> request.
> Unfortunately  there is no debug error to check the query that mapserver
> runs.
> ________________________________
> Απο: Rahkonen Jukka <Jukka.Rahkonen at mmmtike.fi>
> Προς: 'anddreas2' <anddreas2 at yahoo.gr>; "'mapserver-users at lists.osgeo.org'"
> <mapserver-users at lists.osgeo.org>
> Στάλθηκε: 9:32 π.μ. Πέμπτη, 22 Σεπτεμβρίου 2011
> Θεμα: Re: [mapserver-users] Re: Mapserver 6 WMS / PostGIS Problem
>
> 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
>>
>
>
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>
>