Skip site navigation (1) Skip section navigation (2)

pgsql: Tweak create_index_paths()'s test for whether to consider abitm

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Tweak create_index_paths()'s test for whether to consider abitm
Date: 2011-01-11 17:13:43
Message-ID: E1Pchmx-0003jI-8E@gemulon.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-committers
Tweak create_index_paths()'s test for whether to consider a bitmap scan.

Per my note of a couple days ago, create_index_paths would refuse to
consider any path at all for GIN indexes if the selectivity estimate came
out as 1.0; not even if you tried to force it with enable_seqscan.  While
this isn't really a bad outcome in practice, it could be annoying for
testing purposes.  Adjust the test for "is this path only useful for
sorting" so that it doesn't fire on paths with nil pathkeys, which will
include all GIN paths.

Branch
------
master

Details
-------
http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=9d1ac2f5fa4043529dbaff5ebdc73405fa73207b

Modified Files
--------------
src/backend/optimizer/path/indxpath.c |    4 ++--
1 files changed, 2 insertions(+), 2 deletions(-)

pgsql-committers by date

Next:From: Jan UrbaƄskiDate: 2011-01-11 17:37:15
Subject: Re: autogenerating error code lists (was Re: [COMMITTERS] pgsql: Add foreign data wrapper error code values for SQL/MED.)
Previous:From: Tom LaneDate: 2011-01-11 16:11:37
Subject: Re: autogenerating error code lists (was Re: [COMMITTERS] pgsql: Add foreign data wrapper error code values for SQL/MED.)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group