Optimizing PostGIS.

[Luca Manganelli]

Hi,

I'm trying to optimizie a postgis table.

I did "shp2pgsql" command to convert a large shapefile (17 MB, over
5000 features) then I imported it into postgres 8.1.
I created spatial index and I did VACUUM ANALYZE on that table.
I followed the steps in "Performance tips" on Postgis Documentation at
http://postgis.refractions.net/docs/ch05.html (expecially in 5.2 and
5.3).

BUT, in my mapserver the shapefile drawn at max extent is somewhat
50%-100% faster
than Postgis. That performance gain reduces to a 10%-30% in lower scales.
If I do a point query on Postgis table, it is not much faster (but the
performances are often equals!!)...

Any idea?

--
"Work only as many hours as you can be productive and only as many hours as
 you can sustain."  - Kent Beck, in "Extreme Programming Explained"

http://www.trapanator.com/blog