• Tom Lane's avatar
    Fix compare_fuzzy_path_costs() to behave a bit more sanely. The original · 37c443ee
    Tom Lane authored
    coding would ignore startup cost differences of less than 1% of the
    estimated total cost; which was OK for normal planning but highly not OK
    if a very small LIMIT was applied afterwards, so that startup cost becomes
    the name of the game.  Instead, compare startup and total costs fuzzily
    but independently.  This changes the plan selected for two queries in the
    regression tests; adjust expected-output files for resulting changes in
    row order.  Per reports from Dawid Kuroczko and Sam Mason.
    37c443ee
geometry_2.out 20 KB