Opened 9 years ago

Closed 9 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 strk, 9 years ago

Could you provide a testcase for regress/estimatedextent.sql ?

comment:3 by elpaso, 9 years ago

Patch and additional test cases provided in https://github.com/postgis/postgis/pull/79

comment:4 by strk, 9 years ago

Milestone: PostGIS 2.2.1PostGIS 2.3.0
Resolution: fixed
Status: newclosed
Version: 2.2.xtrunk

Patch committed as r14490 in trunk (2.3.0). Thanks Alessandro !

Note: See TracTickets for help on using tickets.