| From: | Bruce Momjian <bruce(at)momjian(dot)us> |
|---|---|
| To: | Vincenzo Romano <vincenzo(dot)romano(at)notorand(dot)it> |
| Cc: | PostgreSQL General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Inheritance efficiency |
| Date: | 2010-04-26 14:01:44 |
| Message-ID: | 201004261401.o3QE1ib24071@momjian.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | akp geek | 2010-04-26 14:43:03 | Table Bloat still there after the Vacuum |
| Previous Message | Bruce Momjian | 2010-04-26 13:32:11 | Re: [GENERAL] trouble with to_char('L') |