[Qgis-user] Postgis speed with QGIS

[Alex Mandel]

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