On 1/4/18 12:00, Robert Haas wrote: >> The catalog representations of partitioned tables and partitioned >> indexes are completely different, which may or may not be desirable. > > How so?
If someone wants to write a query, show me all the partitions of this table versus show me all the partitions of this index, intuitively, those could be the same, different only by some relkind references. Currently, you'd have to write two completely different queries. It's not a big deal, but it's a consideration. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services