[postgis-users] Why postgis is so slow?

[strk at refractions.net]

Bai:
	- what postgis version [ select postgis_full_version() ] ?
	- what postgresql version [ select version() ] ?
	- what sql queries are being run by qgis and udig ?

... should make a "Reporting bugs" section in manual ...

--strk;


On Wed, Sep 14, 2005 at 02:47:00PM +0800, Bai Jianhua wrote:
> I import the sample data of ESRI ArcIMS(SantaClara/sc_streets, about
> 14m) into PostGIS, but when I try to create the index with postgresql
> CREATE INDEX and VACCUM ANALYSIS, I found that it is very slow,
> especially the VACCUM ANALYSIS command, I run postgresql in a Pentium
> 1G PC with 512m RAM,  It almost took me twenty minutes. further more,
> I found the speed of PostGIS is very slow even if I have create the
> index. It tooks almost double time then reading and drawing data from
> shapefile. (I test this with Quantum GIS and UDig)
> 
> Anybody interests with this question can get udig at 
> http://udig.refractions.net/confluence/display/UDIG/Home
> 
> and get Quantum GIS at http://qgis.org/
> 
> 
> best regards.
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users