Postgres Pro
Downloads
Home   >   mailing lists

Thread: pgsql: Teach choose_bitmap_and() to actually be choosy --- that is, try

pgsql: Teach choose_bitmap_and() to actually be choosy --- that is, try

From
tgl@svr1.postgresql.org (Tom Lane)
Date:
Log Message:
-----------
Teach choose_bitmap_and() to actually be choosy --- that is, try to
make some estimate of which available indexes to AND together, rather
than blindly taking 'em all.  This could probably stand further
improvement, but it seems to do OK in simple tests.

Modified Files:
--------------
    pgsql/src/backend/optimizer/path:
        indxpath.c (r1.176 -> r1.177)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/path/indxpath.c.diff?r1=1.176&r2=1.177)