[postgis-users] Why postgis is so slow?

[Paul Ramsey]

That's PostGIS from the Windows pginstaller, isn't it? I found that  
PostGIS abnormally slow as well, particularly in cases of large  
features. It seemed limited to that particular combo: 0.9, windows,  
using that particular installer.

Try using Mark's version:
- get pginstaller, but do *not* install the postgis that is included  
in it
- get Mark's windows postgis installer (linked from postgis downloads  
site) and install that

Paul

On 14-Sep-05, at 6:07 AM, Bai Jianhua wrote:

> Sorry for my cursoriness .
>
> These are the output ofselect version() and select  
> postgis_full_version().
> "PostgreSQL 8.0.3 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC)
> 3.4.2 (mingw-special)"
> "POSTGIS="0.9.1" GEOS="2.1.1" PROJ="Rel. 4.4.9, 29 Oct 2004" USE_STATS
> DBPROC="0.0.1" RELPROC="0.0.1""
>
> I didn't use any query. I just load the full data and then pan and
> zooming in & zooming out the map.  I will try new version of postgis
> and tell you the result.
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>