[Bizgres-general] constraint exclusion (table partitioning) not working?

[Josh Berkus]

Bob,

> Limit  (cost=1506.01..1508.51 rows=1000 width=8)
>     ->  Sort  (cost=1506.01..1531.96 rows=10382 width=8)
>           Sort Key: public.ping.id
>           ->  Result  (cost=0.00..813.44 rows=10382 width=8)
>                 One-Time Filter: false
                ^^^^^^^^^^^^^^^^^^^
Verdict from Simon: nothing below this line is being executed.  Try 
actually running the query -- you'll see it's very fast.   We should 
document this though so that people know what they're looking at.

>                 ->  Append  (cost=0.00..813.44 rows=10382 width=8)
>                       ->  Index Scan using ping_pkey on ping  
> (cost=0.00..8.30 ro
> ws=2 width=8)
>                             Index Cond: ((id >= 0) AND (id <= 10000))
>                       ->  Index Scan using ping_20050816_pkey on  
> ping_20050816 pi
> ng  (cost=0.00..3.02 rows=1 width=8)

-- 
Josh Berkus                GreenPlum Inc
Community Liason       www.greenplum.com
415-752-2500       jberkus at greenplum.com