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

[Josh Berkus]

Bob,

> I don't think that's true, there's no tables referenced above there  
> -- besides, I can prove that the runtime is abysmal for a very very  
> selective query supported by the constraints and the primary key  
> index (below).  public.ping is empty, because it's the parent table.  
> If I do really dumb queries that satisfy every check constraint, it  
> seems to use constraint exclusion:

Do you have this loaded into PostgreSQL 8.1 yet?   I'd like to see the same 
query on 8.1.   If it works there, we'll know exactly what we need to fix.

Otherwise, we'll check the bizgres patch code later this week.

--Josh

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