Peter Eisentraut wrote: > But what are the uses for dealing with partial partition hierarchies? > How easy do we need to make that?
If you have multilevel partitioning, say partitions per year per site. What is the volume of 2017 compared to 2016, on each site? I don't think it needs to be super easy, but it should be reasonable. I think pg_partition_parent() should be a simple function doing one catalog lookup (already implemented as get_partition_parent(), but needs a "missing_ok" case), and pg_partition_root() an iterative version of that. -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
