On Sun, Apr 23, 2006 at 11:12:23PM -0400, Tom Lane wrote:
> We removed the repeated-indexscan plan type in favor of bitmap scans.
> I'm not immediately aware of any reason why we shouldn't have ... if
> there is any case where the pre-8.1 plan style wins, it'd have to be
> a pretty narrow scenario.
Michael Fuhr <[EMAIL PROTECTED]> writes:
> Is it expected that the planner in 8.1.3 (CVS) and HEAD doesn't use
> an index scan for the second query below when bitmap scans are
> disabled?
You mean this one?
> test=> EXPLAIN SELECT * FROM foo WHERE id IN (1, 2);
That's not an indexable condition,
Is it expected that the planner in 8.1.3 (CVS) and HEAD doesn't use
an index scan for the second query below when bitmap scans are
disabled? Disabling sequential scans as well results in the planner
using a bitmap scan.
test=> CREATE TABLE foo (id integer PRIMARY KEY);
NOTICE: CREATE TABLE / PRI
