[postgis-users] Postgis performance

TECHER David davidtecher at yahoo.fr
Mon Apr 16 10:58:33 PDT 2007


Hi Ibrahim

Please take a look at 
http://postgis.refractions.net/docs/ch04.html#id2709413 questions 
4.7.2.3 and 4.7.2.4

I hope these helps!

Ibrahim Khachab a écrit :
> Hi to you all,
>
> I'm new with geographic data and I'm trying to set a server with 
> mapserver/posgis.
> It is a dual Xeon 2.8Ghz cpus machine with 2Gbyte of Ram.
> I have some data in SHP files that I converted to postgis data with 
> shp2pgsql.
> I made some test with some map file and I noticed a strange thing:
> The same maps  with the shp file are 10 times faster than those with 
> the Postgis data.
> What can be the problem.
> How I may debug about this?
> I'm trying to read a lot these days about Postgresql perfoemance but 
> till now I found nothing that could change this situation.
>
>
> Thanks
>
> Ibrahim
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>


	

	
		
___________________________________________________________________________ 
Yahoo! Mail réinvente le mail ! Découvrez le nouveau Yahoo! Mail et son interface révolutionnaire.
http://fr.mail.yahoo.com



More information about the postgis-users mailing list