Re: [HACKERS] INHERITS doesn't offer enough functionality

[Hiroshi Inoue]

Chris wrote: > It's pretty clear to me that an inherited index should be only one > index. There may be a case for optional non-inherited indexes (CREATE > INDEX ON ONLY foobar), but if the index is inherited, it is just one > index. > > At the end of the day though, the reason is only performance. The > semantics should be the same no matter whether implemented as multiple > indexes or not. Performance is much better with one index though.(*) > Is it true ? How to guarantee the uniqueness using multiple indexes ? Regards. Hiroshi Inoue