• Tom Lane's avatar
    Apply the heuristic proposed by Taral (see pgsql-general archives for · 003dd965
    Tom Lane authored
    2-Oct-98 or TODO.detail/cnfify) to decide whether we want to reduce
    WHERE clause to CNF form, DNF form, or neither.  This is a HUGE win.
    The heuristic conditions could probably still use a little tweaking to
    make sure we don't pick CNF when DNF would be better, or vice versa,
    but the risk of exponential explosion in cnfify() is gone.  I was able
    to run ten-thousand-AND-subclause queries through the planner in a
    reasonable amount of time.
    003dd965
prepqual.c 24.8 KB