Re: Another question about partitioning

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