Re: INHERITS doesn't offer enough functionality - Mailing list pgsql-hackers

From Chris
Subject Re: INHERITS doesn't offer enough functionality
Date
Msg-id 39EEE1D6.F455FEF9@bitmead.com
Whole thread Raw
In response to Re: INHERITS doesn't offer enough functionality  ("Oliver Elphick" <olly@lfix.co.uk>)
List 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.


pgsql-hackers by date:

Previous
From: Thomas Lockhart
Date:
Subject: Re: Re: pg_dump docs
Next
From: Matthew
Date:
Subject: RE: Postgre7.0.2 drop user bug