On Mon, 11 Feb 2019 at 20:49, PG Bug reporting form
<noreply@postgresql.org> wrote:
> https://www.postgresql.org/docs/current/ddl-partitioning.html
>
> 5.10.5. Partitioning and Constraint Exclusion
> Constraint exclusion is only applied during query planning; unlike partition
> pruning, it cannot be applied during query execution.
>
> Is it supposed to be "unlike partition pruning, it can be applied during
> query execution"?
That's a bit confusing. "it" looks like must have been intended to
reference constraint exclusion, but since partition pruning was
mentioned afterwards, then it makes more sense to apply it to that.
Maybe it would be more clear to write:
Constraint exclusion is only applied during query planning; unlike
partition pruning which can also be applied during query execution.
Small patch doing it that way is attached.
--
David Rowley http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services