Horton

Re: selecting from partitions and constraint exclusion

Robert Haas <robertmhaas@gmail.com>

View thread View on postgr.es
From: Robert Haas <robertmhaas@gmail.com>
To: Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Cc: Pg Hackers <pgsql-hackers@postgresql.org>
Date: 2019-03-25T15:21:32Z
Lists: pgsql-hackers 
On Wed, Mar 20, 2019 at 12:37 AM Amit Langote
<Langote_Amit_f8@lab.ntt.co.jp> wrote:
> That's because get_relation_constraints() no longer (as of PG 11) includes
> the partition constraint for SELECT queries.

What commit made that change?

This sounds to me like maybe it should be an open item.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

Commits

  1. Clean up handling of constraint_exclusion and enable_partition_pruning.