pgsql/src include/optimizer/paths.h backend/op ... - Mailing list pgsql-committers

From Tom Lane
Subject pgsql/src include/optimizer/paths.h backend/op ...
Date
Msg-id 200106051713.f55HDqY09910@hub.org
Whole thread Raw
List pgsql-committers
CVSROOT:    /home/projects/pgsql/cvsroot
Module name:    pgsql
Changes by:    tgl@hub.org    01/06/05 13:13:52

Modified files:
    src/include/optimizer: paths.h
    src/backend/optimizer/path: allpaths.c indxpath.c orindxpath.c

Log message:
    Improve planning of OR indexscan plans: for quals like
    WHERE (a = 1 or a = 2) and b = 42
    and an index on (a,b), include the clause b = 42 in the indexquals
    generated for each arm of the OR clause.  Essentially this is an index-
    driven conversion from CNF to DNF.  Implementation is a bit klugy, but
    better than not exploiting the extra quals at all ...


pgsql-committers by date:

Previous
From: Tom Lane
Date:
Subject: pgsql/src backend/nodes/copyfuncs.c backend/no ...
Next
From: Peter Eisentraut
Date:
Subject: Re: pgsql/ oc/src/sgml/ref/create_function.sgml rc ...