[postgis-users] mapserver db connection

Frances Collier fcollier at preparedresponse.com
Mon Oct 24 14:40:05 PDT 2005


Greg,

I just ran the same queries through pgAdmin III -- I'm assuming that's what
you meant by natively -- and the queries took just as long. I'm not sure
what you mean by the "out-of-the-box" installation. I installed postgres
8.0.4 with the basic Win32 installation. 

The tables are all indexed using gist and recently analyzed. I have not read
anything about geometry stats. Is that another version? 

Also, what is the fastCGI? I'm still learning about all this stuff and
obviously have much more to learn!

Thank you for your response,
Frances Collier

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Gregory
S. Williamson
Sent: Monday, October 24, 2005 2:03 PM
To: PostGIS Users Discussion; postgis-users at postgis.refractions.net
Subject: RE: [postgis-users] mapserver db connection

Frances --

Have you tried running the same queries in postgres natively -- it may be
that postgres is not giving you all that it can, especially if this is an
"out-of-the-box" installation, which is set to allow low end machines to
run, but definitely is not tuned for performance in terms of memory settings
and the like.

Also, are the tables indexed and recently analyzed/had geometry stats done
on them ?

Connecting to postgres can be relatively slow -- I think the fastCGI variant
of MMS may handle this better.

And of course, it *could* be inherent in MMS -- I have read that on this
list that shape files are faster for some purposes.

HTH,

Greg Williamson
DBA
GlobeXplorer LLC
-----Original Message-----
From:	postgis-users-bounces at postgis.refractions.net on behalf of Frances
Collier
Sent:	Mon 10/24/2005 1:29 PM
To:	postgis-users at postgis.refractions.net
Cc:	
Subject:	[postgis-users] mapserver db connection
Hello,

 

I've been trying to find out what exactly Mapserver gets back from Postgis
when querying the tables. I haven't found this to be documented anywhere.
Does Postgis return a shape file, layer, or simply data rows? The reason I'm
asking is that I noticed a huge time difference between connecting to
Postgis and simply calling the shape files - with the Postgis being
significantly slower. I know Postgis offers a lot more functionality, but
for simple comparisons I do not have any type of filter applied.

 

I'd appreciate any knowledge, advice, and/or direction.

 

Thank you,

Frances Collier

 




_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users






More information about the postgis-users mailing list