[postgis-users] Why postgis is so slow?
strk at refractions.net
strk at refractions.net
Tue Sep 13 23:52:48 PDT 2005
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
More information about the postgis-users
mailing list