On Thu, Jan 4, 2018 at 11:44 AM, Peter Eisentraut <peter.eisentr...@2ndquadrant.com> wrote: > I'm not sure why this feature of automatically picking up matching > indexes even exists. Is it for some specific workflows or upgrade > scenarios? It's kind of a surprising feature in a way.
It allows you to avoid building a new indexes unnecessarily when attaching a partition. > The catalog representations of partitioned tables and partitioned > indexes are completely different, which may or may not be desirable. How so? -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company