[Qgis-developer] Trouble with PostGis plugin

[Chris Crook]

Hi Walter

When you connect to the PostGis database make sure that you have selected the "Use estimated metadata" option - this optimises the connection for large datasets - see attached screenshot.  This should greatly improve the connection times for postigs.  (If you are already doing this then may need to look further!)

Cheers
Chris
________________________________________
From: walter.nordmann [walter.nordmann at web.de]
Sent: 10 October 2014 02:29
To: qgis-developer at lists.osgeo.org
Subject: Re: [Qgis-developer] Trouble with PostGis plugin

sorry, no special plugin; just that build in PostGis tool.

mainly i need to the the queries going to the server in order to optimize
some indexes.
even adding EXPLAIn to the Query whould help a lot.



regards
walter



--
View this message in context: http://osgeo-org.1560.x6.nabble.com/Trouble-with-PostGis-plugin-tp5166669p5166687.html
Sent from the Quantum GIS - Developer mailing list archive at Nabble.com.


This message contains information, which may be in confidence and may be subject to legal privilege. If you are not the intended recipient, you must not peruse, use, disseminate, distribute or copy this message. If you have received this message in error, please notify us immediately (Phone 0800 665 463 or info at linz.govt.nz) and destroy the original message. LINZ accepts no responsibility for changes to this email, or for any attachments, after its transmission from LINZ. Thank You.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Screenshot from 2014-10-10 19:33:49.png
Type: image/png
Size: 59510 bytes
Desc: Screenshot from 2014-10-10 19:33:49.png
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20141010/bf843454/attachment-0001.png>