Re: selecting from partitions and constraint exclusion - Mailing list pgsql-hackers

From Amit Langote
Subject Re: selecting from partitions and constraint exclusion
Date
Msg-id 339e6ca5-03e2-1bed-58f6-6be9fe9e1f2d@lab.ntt.co.jp
Whole thread Raw
In response to Re: selecting from partitions and constraint exclusion  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
On 2019/03/26 0:21, Robert Haas wrote:
> 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?

That would be 9fdb675fc5d2 (faster partition pruning) that got into PG 11.

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

I've added this under Older Bugs.

Thanks,
Amit



pgsql-hackers by date:

Previous
From: Thomas Munro
Date:
Subject: Re: Usage of epoch in txid_current
Next
From: Andres Freund
Date:
Subject: setLastTid() and currtid()