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

Josh Berkus jberkus at greenplum.com
Tue Sep 13 22:53:52 GMT 2005


Bob,

> Ok, but if I rewrite it to be id > 0 and id < 10000, it still scans
> every table
>
> EXPLAIN SELECT id FROM ping WHERE id between 0 and 10000 order by id
> limit 1000;

OK, that's a real problem.   Simon is here, I'll talk to him.

--Josh

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



More information about the Bizgres-general mailing list