[Qgis-developer] QGIS Multi-threaded Rendering

Andreas Neumann a.neumann at carto.net
Tue Jan 7 13:23:21 PST 2014

Hi Martin,

I tested it and can confirm that the PostgreSQL pooling works fine and
fast now.

I see more than 4 Postgis connections though. But maybe these
connections are from other plugins using Postgis connections as well.

Good to see progress!


Am 06.01.2014 13:31, schrieb Martin Dobias:
> Hi Andreas
> On Fri, Dec 13, 2013 at 8:31 PM, Andreas Neumann <a.neumann at carto.net> 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

More information about the Qgis-developer mailing list