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 <br...@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
