Re: [Qgis-developer] Trouble with PostGis plugin

2014-10-10 Thread Chris Crook
this then may need to look further!) Cheers Chris From: walter.nordmann [walter.nordm...@web.de] Sent: 10 October 2014 02:29 To: qgis-developer@lists.osgeo.org Subject: Re: [Qgis-developer] Trouble with PostGis plugin sorry, no special plugin; just that build

Re: [Qgis-developer] Trouble with PostGis plugin

2014-10-10 Thread walter.nordmann
Chris Crook wrote 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

Re: [Qgis-developer] Trouble with PostGis plugin

2014-10-10 Thread walter.nordmann
Sandro Santilli-2 wrote Can you send the whole query ? I think there's a class of such issues with big tables that need be addressed (and secured with some automated testcase). I did it again and - performance is ok - no idea what is going on there. :( This part of Qgis is for me like a

[Qgis-developer] Trouble with PostGis plugin

2014-10-09 Thread walter.nordmann
Hi, Running Qgis 2.4 on Ubuntu 14.4 i'm using (or better try to use) the PostGis-Plugin on a really big database (full osm Planet with Tables countaining 5-100 millions of datarecords) First: when adding a PostGis Layer Filter, the plugin is doing a query to get the geometry of the Objects and

Re: [Qgis-developer] Trouble with PostGis plugin

2014-10-09 Thread Paolo Cavallini
Il 09/10/2014 13:59, walter.nordmann ha scritto: Hi, Running Qgis 2.4 on Ubuntu 14.4 i'm using (or better try to use) the PostGis-Plugin on a really big database Hi Walter, which plugin do you mean? All the best. -- Paolo Cavallini - www.faunalia.eu Corsi QGIS e PostGIS:

Re: [Qgis-developer] Trouble with PostGis plugin

2014-10-09 Thread walter.nordmann
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: