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

[BrainDrain]

-how did you import your layer data into postgres table? did you use GIST
indexing?
did you use PROCESSING "CLOSE_CONNECTION=DEFER" for your layer?
did you reproject your data?

cluster <gindexname> on <tablename> - just a sql command which you can run
in context of postgis database using psql console app or pgAgmin utils or
other software that helps pgsql developers. This command creates
"physically-allocated" gindex which can boost perfomance for large layers.

I have some layers with 180000-190000 polygons and mapserv draws 256x256
tiles pretty fast for my ajax powered webapp.


SUSANNE wrote:
> 
> Thanks a lot for reply!
> I inserted following line and now postgis query works fine.
> "DATA  'the_geom FROM zobject1 USING UNIQUE gid USING SRID=31282'"
> 
> But I don't get on with optimization. 
> On which place do I have to insert: "cluster gindexname on tablename" ?
> I inserted in postgresql.conf:
> # AUTOVACUUM PARAMETERS
> #---------------------------------------------------------
> vacuum full	
> 
> For me it didn't make any effort. 
> And I am worried because there is only one feature in postgis table,
> nevertheless one redraw from database needs more than 2 minute (I created
> 30
> png tiles 256*256 RGB 24bit).
> I am afraid I am doing something basically wrong!?
> Many thanks in advance for your kind efforts
> Susanne Kalliany
> 
> ----Ursprüngliche Nachricht-----
> Von: mapserver-dev-bounces at lists.osgeo.org
> [mailto:mapserver-dev-bounces at lists.osgeo.org] Im Auftrag von BrainDrain
> Gesendet: Dienstag, 19. August 2008 12:31
> An: mapserver-dev at lists.osgeo.org
> Betreff: Re: [mapserver-dev] speed up layer displaying postgis-mapserver
> 
> 
> 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-tp19032703
> p19047825.html
> Sent from the Mapserver - Dev mailing list archive at Nabble.com.
> 
> _______________________________________________
> mapserver-dev mailing list
> mapserver-dev at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-dev
> 
> _______________________________________________
> mapserver-dev mailing list
> mapserver-dev at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-dev
> 
> 

-- 
View this message in context: http://www.nabble.com/speed-up-layer-displaying-postgis-mapserver-tp19032703p19076195.html
Sent from the Mapserver - Dev mailing list archive at Nabble.com.