[postgis-users] newby performance load to mapserver compared to shapefile

francesco.pirotti at unipd.it francesco.pirotti at unipd.it
Tue Jul 17 23:49:36 PDT 2007

Dear Users,

I have been flirting with PostGIS data for a while, but now I have come
accross a benchmark issue which baffles me.  I loaded a big-bunch of
polygon data (431094 lines in postgres8.1) importing with shp2pgsql
utility (thus with GIST index and all)... I run the vacuum analyze on the
database, but the time mapserver takes to draw all the data is about 20
times slower than a shapfile.

Is this normal?

Thak you for your time.

Francesco Pirotti

More information about the postgis-users mailing list