> db=# \d s_ps.tbl_ps_type_1
> Table "s_ps.tbl_ps_type_1"
...
> Check constraints:
> "tbl_ps_typ_1_type_check" CHECK (type = 1)
> Inherits: tbl_ps
...
> myyearbook=# EXPLAIN ANALYZE SELECT uid FROM tbl_ps WHERE
> type = 1 and
> normalized_text='bush';
>
>
>
> QUERY PLAN
...
> -> Index Scan using index_b_on_type_2 on
> tbl_ps_type_2 tbl_ps
> (cost=0.00..4.53 rows=1 width=4) (actual time=0.099..0.099
> rows=0 loops=1)
> Index Cond: ((normalized_text)::text = 'bush'::text)
> Filter: (type = 1)
Do you have corresponding constraints on all other table partitions ?
btw. I doubt that the many partial indexes are really helpful here.
What you are doing basically only replaces one btree header page.
Andreas