Opened 8 years ago
Closed 8 years ago
#3391 closed enhancement (fixed)
For "parent" tables with INHERITS st_estimatedextent might collect the extent from the "child" tables
| Reported by: | elpaso | Owned by: | pramsey |
|---|---|---|---|
| Priority: | medium | Milestone: | PostGIS 2.3.0 |
| Component: | postgis | Version: | master |
| Keywords: | Cc: | strk@… |
Description
This problem arises when dealing with huge parent tables that have "children" with INHERITS. Even if the children tables have statistics and return st_estimatedextent correctly, running st_estimatedextent on the parent table return an error:
ERROR: stats for "base_table_good.geom" do not exist
Would it be possible to return the st_estimatedextent collecting that of the children tables (if available) instead of returning an error?
Change History (4)
comment:1 by , 8 years ago
comment:3 by , 8 years ago
Patch and additional test cases provided in https://github.com/postgis/postgis/pull/79
comment:4 by , 8 years ago
| Milestone: | PostGIS 2.2.1 → PostGIS 2.3.0 |
|---|---|
| Resolution: | → fixed |
| Status: | new → closed |
| Version: | 2.2.x → trunk |
Patch committed as r14490 in trunk (2.3.0). Thanks Alessandro !
Note:
See TracTickets
for help on using tickets.
Could you provide a testcase for regress/estimatedextent.sql ?