Greetings, * Peter Geoghegan (p...@bowt.ie) wrote: > On Wed, Oct 30, 2019 at 9:23 AM Tom Lane <t...@sss.pgh.pa.us> wrote: > > Well, the *effects* of the feature seem desirable, but that doesn't > > mean that we want an implementation that actually has a shared index. > > As soon as you do that, you've thrown away most of the benefits of > > having a partitioned data structure in the first place. > > Right, but that's only the case for the global index. Global indexes > are useful when used judiciously. They enable the use of partitioning > for use cases where not being able to enforce uniqueness across all > partitions happens to be a deal breaker. I bet that this is fairly > common.
Absolutely- our lack of such is a common point of issue when folks are considering using or migrating to PostgreSQL. Thanks, Stephen
signature.asc
Description: PGP signature
