[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