Re: Another question about partitioning

paul rivers wrote:
> Alex Vinogradovs wrote:
>> Yes, I enter query manually while testing. Here are explain plans :
>>
>> for select count(*) from poll_3 where eid = 72333
>>
>> "Aggregate  (cost=34697.64..34697.65 rows=1 width=0)"
>> "  ->  Seq Scan on poll_3  (cost=0.00..34650.40 rows=18893 width=0)"
>> "        Filter: (eid = 72333)"
>>
>>
>> for for select count(*) from poll where eid = 72333
>>
>> "Aggregate  (cost=320001.59..320001.60 rows=1 width=0)"
>> "  ->  Append  (cost=0.00..319570.78 rows=172323 width=0)"
>> "        ->  Seq Scan on poll  (cost=0.00..27.50 rows=17 width=0)"
>> "              Filter: (eid = 72333)"
>> "        ->  Seq Scan on poll_0 poll  (cost=0.00..14348.85 rows=9014
>> width=0)"
>> "              Filter: (eid = 72333)"
>> "        ->  Seq Scan on poll_1 poll  (cost=0.00..34796.82 rows=18735
>> width=0)"
>> "              Filter: (eid = 72333)"
>> "        ->  Seq Scan on poll_2 poll  (cost=0.00..34993.84 rows=18527
>> width=0)"
>>
> Do you have appropriate check constraints defined on table poll?  Can
> you include a \d poll?
>
> Also, what version is this?
>
> Paul
>
>
>
Sorry, I should have asked: do you have check constraints defined on all
the child poll tables?  So, what's \d poll_3 look like, etc?  You've
already said you're sure constraint exclusion is on, but you're also
sure postmaster was restarted too?

Paul