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

[BrainDrain]

1. DATA "geom from public.construct >>>>USING UNIQUE [id field name] USING
SRID=[your srid or -1 (not recom.)]<<<<" for all postgis layers
this solves problem with msPOSTGISLayerRetrievePGVersion
2. I use cluster gindexname on tablename & vacuum full. +
http://www.powerpostgresql.com/Downloads/annotated_conf_80.html



SUSANNE wrote:
> 
> 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-tp19032703p19047825.html
Sent from the Mapserver - Dev mailing list archive at Nabble.com.