Horton

Re: INHERITS doesn't offer enough functionality

Chris Bitmead <chris@bitmead.com>

View thread
From: Chris <chris@bitmead.com>
To: Hiroshi Inoue <Inoue@tpf.co.jp>
Cc: Oliver Elphick <olly@lfix.co.uk>, Alfred Perlstein <bright@wintelcom.net>, pgsql-hackers@postgresql.org
Date: 2000-10-19T11:58:14Z
Lists: pgsql-hackers 
Hiroshi Inoue wrote:

> > 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 ?

Well you'd have to check every index in the hierarchy. As I said,
inefficient.