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

[francesco.pirotti at unipd.it]

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