Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Use estimated data in PG connection doesn't work #21293

Closed
qgib opened this issue Aug 19, 2015 · 3 comments
Closed

Use estimated data in PG connection doesn't work #21293

qgib opened this issue Aug 19, 2015 · 3 comments
Labels
Bug Either a bug report, or a bug fix. Let's hope for the latter!

Comments

@qgib
Copy link
Contributor

qgib commented Aug 19, 2015

Author Name: Luca Lanteri (Luca Lanteri)
Original Redmine Issue: 13232
Affected QGIS version: 2.8.2


It seems that the option "Use estimated data" in pg connection is ignored.
Qgis always use st_extent instead() of st_estimated_extent() when a new layer is loaded from PG.
It worked fine in 2.6.
Tested on 2.8 and 2.10

@qgib
Copy link
Contributor Author

qgib commented Aug 19, 2015

Author Name: Jürgen Fischer (@jef-n)


Are there stats for the tables in question (see pg_stats)? QGIS only uses st_estimated_extent on analyzed tables.

@qgib
Copy link
Contributor Author

qgib commented Aug 19, 2015

Author Name: Luca Lanteri (Luca Lanteri)


I've done some other tests. The problem seems to be that I use INHERITS table. Pg_stats is correctly used for the child table but when I load the data from parent table they're ignored.

@qgib
Copy link
Contributor Author

qgib commented Dec 15, 2015

Author Name: Alessandro Pasotti (@elpaso)


This is not a bug in QGIS but in POstGIS, hopefully fixed upstream:

postgis/postgis@92865ad


  • status_id was changed from Open to Closed

@qgib qgib added the Bug Either a bug report, or a bug fix. Let's hope for the latter! label May 25, 2019
@qgib qgib closed this as completed May 25, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Bug Either a bug report, or a bug fix. Let's hope for the latter!
Projects
None yet
Development

No branches or pull requests

1 participant