On 28 Aug 2009, at 21:13, Steven Lembark wrote:
If I query on foo_id % 8, explain shows the optimizer using the constraint (1). If I just query on foo_id = 100, the exclusion is not used (2). What would be the best way to feed the optimizer enough data to use the partitioning with equality queries?
What about foo_id = 100 AND foo_id % 8 = 100 % 8 ? Alban Hertroys -- If you can't see the forest for the trees, cut the trees and you'll see there is no forest. !DSPAM:737,4a9911a711861381017743! -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
