Ibrar Ahmed <ibrar.ah...@gmail.com> writes: > A global index by very definition is a single index on the parent table > that maps to many > underlying table partitions.
I believe that the current design of partitioning is explicitly intended to avoid the need for such a construct. It'd be absolutely disastrous to have such a thing from many standpoints, including the breadth of locking needed to work with the global index, the difficulty of vacuuming, and the impossibility of cheaply attaching or detaching partitions. In other words, this is a "feature" we do not want. regards, tom lane