[mapserver-dev] speed up layer displaying postgis-mapserver

SUSANNE susanne.kalliany at tefis.at
Mon Aug 18 10:17:36 EDT 2008


Dear Mapserver List!

I am developing Mapserver-application (ms4w 2.2.7, postgres 1.8.2) since
half a year. Now some debugging and optimization work has to be done.
I am doing quite well with programming, but I am not very experienced in
installation - optimization issues.

I would be very grateful for some hints to answer the follwing questions or
how to improve performance generally.

1. How can I get rid of following error: msPOSTGISLayerRetrievePGVersion():
Query error. Error executing POSTGIS statement
(msPOSTGISLayerRetrievePGVersion():select substring(version() from 12 for
(position('on' in version()) - 13))
I did some in internet searches but I could'nt take head or tale of it.

2. Should I increase max_buffer in postgresql.conf?
I found the tip
(http://mapserver.gis.umn.edu/docs/howto/optimizevector/html2pdf), but I
don't have such an item in my postgres.conf file and also don't know which
value I have to set.

3. How to improve displaying of 5 postgres-supported editable layer. It
takes some time even when these layers are empty!? 
(Installation uses kaMap in javascript-php enviroment)

thanks a lot, Susanne Kalliany
-- 
View this message in context: http://www.nabble.com/speed-up-layer-displaying-postgis-mapserver-tp19032703p19032703.html
Sent from the Mapserver - Dev mailing list archive at Nabble.com.



More information about the mapserver-dev mailing list