OK, after enabling "Use estimated metadata" on the connection, the Data
Source Manager comes up (doesn't hang). I am able to select a table and apply a
filter. After a brief delay, QGIS starts to load data. However, is see an odd
query consuming resources in the database:
SELECT st_extent("coordinate") FROM "public"."device_location"
The device_location table is the partitioned table with billions of rows. I
wound expect the above query to include the filter (where clause) I defined in
the Data Source Manager.
To summarize, I am able to create a filter before loading data thanks to the
"Use estimated metadata" but I seem to have found a new issue.
Thanks,Peter
On Tuesday, August 6, 2019, 3:34:06 AM EDT, Jürgen E. Fischer
<j...@norbit.de> wrote:
Hi Peter,
On Mon, 05. Aug 2019 at 22:29:19 +0000, Peter Borissow wrote:
> I looked at the Data Source Manager (Layer -> Add Layer -> Add PostGIS
> Layers...) but I don't see any filtering options there and the app hangs when
> I hit the "Connect" button.
Did you enable "Use estimated metadata" on that connection?
Jürgen
--
Jürgen E. Fischer norBIT GmbH Tel. +49-4931-918175-31
Dipl.-Inf. (FH) Rheinstraße 13 Fax. +49-4931-918175-50
Software Engineer D-26506 Norden https://www.norbit.de
QGIS release manager (PSC) Germany IRC: jef on
FreeNodenorBIT Gesellschaft fuer Unternehmensberatung und Informationssysteme
mbH
Rheinstrasse 13, 26506 Norden
GF: Juergen Fischer, Nils Kutscher HR: Amtsgericht Aurich HRB 100827
Datenschutzerklaerung: https://www.norbit.de/83/
_______________________________________________
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user _______________________________________________
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
