[Qgis-developer] Using PostGIS on a slow connection

Jonathan Moules jonathanmoules at warwickshire.gov.uk
Wed Feb 26 06:01:36 PST 2014

It sounds like the PostGIS connection provider could use some optimisations.

The Oracle provider had/has a few which are being resolved (thanks
Jurgen!), but it does first require identifying what queries are being run
during what actions. If you have access, watch what queries are running on
PostGIS when you perform actions within QGIS.

On 26 February 2014 13:52, Paolo Cavallini <cavallini at faunalia.it> wrote:

> Il 26/02/2014 13:29, Andreas Neumann ha scritto:
> > Hi,
> >
> > As far as I know libpq does not support compression.
> >
> > There is a lengthy discussion on libpq compression at
> > http://postgresql.1045698.n5.nabble.com/libpq-compression-td5712541.html
> Some of the slowness is understandable, some not really, e.g. why
> deactivating a layer in the legend should require time?
> All the best.
> --
> Paolo Cavallini - www.faunalia.eu
> QGIS & PostGIS courses: http://www.faunalia.eu/training.html
> _______________________________________________
> Qgis-developer mailing list
> Qgis-developer at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-developer

This transmission is intended for the named addressee(s) only and may 
contain sensitive or protectively marked material up to RESTRICTED and 
should be handled accordingly. Unless you are the named addressee (or 
authorised to receive it for the addressee) you may not copy or use it, or 
disclose it to anyone else. If you have received this transmission in error 
please notify the sender immediately. All email traffic sent to or from us, 
including without limitation all GCSX traffic, may be subject to recording 
and/or monitoring in accordance with relevant legislation.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20140226/51372338/attachment.html>

More information about the Qgis-developer mailing list