From ea05b221c2ff9d180f632ae90c806e984f15ed0d Mon Sep 17 00:00:00 2001 From: Michael Paquier Date: Tue, 12 Feb 2019 12:01:56 +0900 Subject: [PATCH] Clarify docs about limitations of constraint exclusion with partitions The current wording can confuse the reader about constraint exclusion being available at query execution, but this only applies to partition pruning. Reported-by: Shouyu Luo Author: David Rowley Reviewed-by: Chapman Flack, Amit Langote Discussion: https://postgr.es/m/15629-2ef8b22e61f8333f@postgresql.org --- doc/src/sgml/ddl.sgml | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/doc/src/sgml/ddl.sgml b/doc/src/sgml/ddl.sgml index ef713a5a1c..8314fce78f 100644 --- a/doc/src/sgml/ddl.sgml +++ b/doc/src/sgml/ddl.sgml @@ -4511,8 +4511,8 @@ EXPLAIN SELECT count(*) FROM measurement WHERE logdate >= DATE '2008-01-01'; - Constraint exclusion is only applied during query planning; unlike - partition pruning, it cannot be applied during query execution. + Constraint exclusion is only applied during query planning, unlike + partition pruning, which can also be applied during query execution. -- 2.49.0