• Tom Lane's avatar
    Create a third option named "partition" for constraint_exclusion, and make it · 445ce157
    Tom Lane authored
    the default.  This setting enables constraint exclusion checks only for
    appendrel members (ie, inheritance children and UNION ALL arms), which are
    the cases in which constraint exclusion is most likely to be useful.  Avoiding
    the overhead for simple queries that are unlikely to benefit should bring
    the cost down to the point where this is a reasonable default setting.
    Per today's discussion.
    445ce157
postgresql.conf.sample 15.9 KB