[Spam: 3.72] RE: [mapguide-users] PostGIS - whatiswrongwhitthat?-my todo list

[Traian Stanev]

I upped the memory buffers to a gig. Saw no big difference (still 65+
seconds). I also noticed that even though mgserver and pgsql are
separate processes, my two CPUs never go much above 50% total usage for
the duration of the request. I tried viewing the original SHP data
through the OGR provider and it takes around 6 seconds to draw.
Unfortunately, I don't have the time to fiddle with PG settings (that,
and I'm SQL-averse), so I probably won't go into this particular
performance issue any further.

Traian


-----Original Message-----
From: mapguide-users-bounces at lists.osgeo.org
[mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of Jason Birch
Sent: Thursday, February 01, 2007 2:02 PM
To: MapGuide Users Mail List
Subject: RE: [Spam: 3.72] RE: [mapguide-users] PostGIS -
whatiswrongwhitthat?-my todo list


100K polygons is not such a great idea, but out of the box PostgreSQL is
not well tuned for PostGIS.  Can you try some of the stepps here and see
if you notice a difference?

http://postgis.refractions.net/pipermail/postgis-users/2006-March/011539
.html

Jason 

-----Original Message-----
From: mapguide-users-bounces at lists.osgeo.org
[mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of Traian
Stanev
Sent: Thursday, February 01, 2007 08:07
To: MapGuide Users Mail List
Subject: RE: [Spam: 3.72] RE: [mapguide-users] PostGIS -
whatiswrongwhitthat?- my todo list


I just tried it with a layer with 100K polygons. It takes about 70
seconds for the layer to preview in MapGuide. I was watching the CPU
usage during that time and about 70% of the time was spent in the
postgres process (the rest was in the mgserver process, which includes
the provider logic and OGR itself, and the rendering of the layer). So I
place the blame on Postgres. I verified that the spatial indexing works
-- once I zoom in things get much faster.

Traian
 
_______________________________________________
mapguide-users mailing list
mapguide-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-users