Re: Inheritance efficiency

Vincenzo Romano wrote:
> Hi all.
>
> I'm wondering how efficient the inheritance can be.
> I'm using the constraint exclusion feature and for each child table
> (maybe but one) I have a proper CHECK constraint.
> How efficient can the query planner be in choosing the right child
> tables in the case of, say, thousands of them?
> Would the selection process behave linearly, logarithmically or what?

It is fine for dozens of child tables, but not thousands; it does need
improvement.


> And now it comes to my mind the same question for partial indexes.
> That is, if I had a lot (really a lot) of small partial indexes over a
> very large table, how efficient can the query planner be
> in selecting the right indexes?
>
> Will these answers change in v9?

No.

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com