On Sep 24, 2006, at 2:12 PM, Ben wrote:
Ah, so I do. Thanks, that helps an awful lot.
But the plan is still twice as expensive as when I put in the
static values. Is it just unreasonable to expect the planner to see
that there aren't many rows in the subselect, so to use the bitmap
scans after all?
Based on your initial post, it probably should know that it's only
getting 15 rows (since it did in your initial plan), so it's unclear
why it's not choosing the bitmap scan.
Can you post the results of EXPLAIN ANALYZE?
--
Jim Nasby jim@xxxxxxxxx
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
