Hi Andreas On Fri, Dec 13, 2013 at 8:31 PM, Andreas Neumann <[email protected]> wrote: > Hi Martin, > > I guess I am also running into the PostgreSQL issue. In general my > PostgreSQL based projects with many layers freeze after a very short > time, while the SpatiaLite based projects work very nicely. > > Too many PostgreSQL connections? Can we limit the PostgreSQL connections > or can you better re-use existing connections?
A quick followup - today I have pushed some changes that introduce a connection pool for PostgreSQL. This should remove the problem with too many connections. It limits the maximum number of concurrent connections from one QGIS instance to four. Also, when the connections are not used for some time, they get closed to save resources (right now it is after one minute). Please test and let me know if things work better now. I will probably also look at pooling of SpatiaLite connections - right now the queries within SQLite are serialized, so within one SpatiaLite database you will not see any performance gain with parallel rendering. Regards Martin _______________________________________________ Qgis-developer mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/qgis-developer
