AW: AW: AW: [mapserver-dev] speed up layer displayingpostgis-mapserver

BrainDrain paulborodaev at gmail.com
Wed Sep 3 01:24:02 EDT 2008


Yes )) it's related to bug1730
I spend hour investigating which dll hangs mapserv after updateing yo 2.2.8
well I found that it is mysql
and the next day I saw that version 2.2.9 relesed with just replaced dll
with older version))

SUSANNE wrote:
> 
> I am using ms4w 2.2.8.
> Thanks a lot for your reply.
> Greetings from Austria, Susanne Kalliany
> 
> 
> 
> BrainDrain wrote:
>> 
>> I think I know what is your problem. What version of ms4w you're using?
>> 
>> SUSANNE wrote:
>>> 
>>> 120 tiles are 4*30 tiles (30 tiles for covering the screen, 4 layers).
>>> These tiles are empty at the beginning of the project because there are
>>> no
>>> data. During mapping I have a routine only to update changed tiles.
>>> Do you have a better idea?
>>> Thanks for helping, 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: Donnerstag, 21. August 2008 13:46
>>> An: mapserver-dev at lists.osgeo.org
>>> Betreff: Re: AW: AW: [mapserver-dev] speed up layer
>>> displayingpostgis-mapserver
>>> 
>>> 
>>> why you need 120 tiles at once? for what? 120... it will take a time,
>>> but it
>>> needless in most cases to generate so many in one operation.
>>> and why empty?
>>> try to use Proj4 projection string instead of epsg code.
>>> 
>>> SUSANNE wrote:
>>>> 
>>>> Excuse me; I sent my previous mail unintentionally!
>>>> 
>>>> I am really afraid I am doing something basically wrong; but don't know
>>>> how
>>>> to go on.
>>>> 
>>>> Thanks a lot for your help, Susanne Kalliany
>>>> 
>>>> 
>>>> -----Ursprüngliche Nachricht-----
>>>> Von: mapserver-dev-bounces at lists.osgeo.org
>>>> [mailto:mapserver-dev-bounces at lists.osgeo.org] Im Auftrag von Susanne
>>>> Kalliany
>>>> Gesendet: Donnerstag, 21. August 2008 12:50
>>>> An: 'BrainDrain'; mapserver-dev at lists.osgeo.org
>>>> Betreff: AW: AW: [mapserver-dev] speed up layer displaying
>>>> postgis-mapserver
>>>> 
>>>> Sorry for being so nasty. 
>>>> I did like you told:
>>>> 
>>>> LAYER
>>>>    NAME zobject1
>>>>    GROUP zobject1
>>>>    STATUS ON
>>>>    MAXSCALE 30000
>>>>    TYPE POLYGON
>>>>    CONNECTIONTYPE postgis
>>>>    CONNECTION 'user=postgres password=susi dbname=tefisdb
>>>> host=localhost
>>>> port=5432'
>>>>    DATA  'the_geom FROM zobject1 USING UNIQUE gid1 USING SRID=31282'
>>>> 	PROCESSING 'CLOSE_CONNECTION=DEFER'
>>>>    PROJECTION
>>>>    		'init=epsg:31282'
>>>>    END
>>>> 
>>>> But nevertheless for drawing 4 (empty) postgis layers -120 tiles
>>>> 256*256 I
>>>> need 3.5 minutes.
>>>> 
>>>> 
>>>> -----Ursprüngliche Nachricht-----
>>>> Von: mapserver-dev-bounces at lists.osgeo.org
>>>> [mailto:mapserver-dev-bounces at lists.osgeo.org] Im Auftrag von
>>>> BrainDrain
>>>> Gesendet: Mittwoch, 20. August 2008 21:15
>>>> An: mapserver-dev at lists.osgeo.org
>>>> Betreff: Re: AW: [mapserver-dev] speed up layer displaying
>>>> postgis-mapserver
>>>> 
>>>> 
>>>> -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-tp19032703
>>>> p19076195.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
>>>> 
>>>> _______________________________________________
>>>> 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-tp19032703
>>> p19087077.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-tp19032703p19283092.html
Sent from the Mapserver - Dev mailing list archive at Nabble.com.



More information about the mapserver-dev mailing list