[mapserver-users] Really slow map creation from POSTGIS DB

[Julien Cigar]

On 04/28/2012 14:44, Matt McClelland wrote:
> Hi All
>
> I have a set of contours in a SHP file
> If I point my map file to the SHP file I can generate a WMS image in 
> under 1 second
> Shp file is just shy of 200MB
>
> I then use shp2pgsql to load the same dataset into the DB
> I added an index for the_geom
> And am requesting the data in the mapfile using the same EPSG
>
> The map draws correclty but is now taking about 30secs when using the DB.
>

are you sure your postgresql is well configured ? can you pastebin your 
postgresql.conf and some details about your configuration ?

> Any ideas on how to make it faster.
>
> Thanks
>
> Matt  :)
>
>
>
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20120428/c4c8917a/attachment.htm>