On 06/09/2010 03:55 PM, John Abraham wrote: > Loading and manipulating a PostGIS layer in QGIS is quite slow right now. I > have GIST indexes. I'm running both QGIS and PostGIS on the same machine. > I'm currently blaming PostgreSQL and am currently exploring configuration and > hardware options to make my PostgreSQL installation faster. > > Any suggestions on PostgreSQL configuration? Anything else I should try? > > What are others' experiences? Is there any hope for making my PostGIS layers > as fast as my shape file layers? > > -- > John Abraham
It never hurts to optimize your postgres server. pgtune is a little script to help you do that, not everything it suggests works but it will show you the important settings to tweak, escpecially around how much ram postgres is allowed to use (the default is quite small). http://pgfoundry.org/projects/pgtune/ Enjoy, Alex _______________________________________________ Qgis-user mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/qgis-user
