Hi, I turned PostgreSQL statement logging on and I can see this line to appear: execute (unnamed): SELECT postgis_version()
Mapserv.exe is eating now 52% of CPU and nothing else seems to happen. -Jukka- > -----Alkuperäinen viesti----- > Lähettäjä: thomas bonfort [mailto:[email protected]] > Lähetetty: 22. syyskuuta 2011 16:47 > Vastaanottaja: Rahkonen Jukka > Kopio: Andreas Douvalis; [email protected] > Aihe: Re: Σχετ: [mapserver-users] Re: Mapserver 6 WMS / > PostGIS Problem > > 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 <[email protected]>: > > 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:[email protected]] > > 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 <[email protected]> > > Προς: 'anddreas2' <[email protected]>; > "'[email protected]'" > > <[email protected]> > > Στάλθηκε: 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ä: [email protected] > >> [mailto:[email protected]] Puolesta anddreas2 > >> Lähetetty: 22. syyskuuta 2011 8:52 > >> Vastaanottaja: [email protected] > >> 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 > >> [email protected] > >> http://lists.osgeo.org/mailman/listinfo/mapserver-users > >> > > > > > > _______________________________________________ > > mapserver-users mailing list > > [email protected] > > http://lists.osgeo.org/mailman/listinfo/mapserver-users > > > > >
_______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
