Postgres Pro
Downloads
Home   >   mailing lists

Re: Internal error XX000 with enable_partition_pruning=on, pg 11beta1 on Debian - Mailing list pgsql-hackers

From David Rowley
Subject Re: Internal error XX000 with enable_partition_pruning=on, pg 11beta1 on Debian
Date
Msg-id CAKJS1f_Edtk0k1zm=6Vy4N=mL5k6zbxVoo1XRRLeUoSjBL-NNg@mail.gmail.com
Whole thread Raw
In response to Re: Internal error XX000 with enable_partition_pruning=on, pg 11beta1 on Debian  (Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>)
Responses Re: Internal error XX000 with enable_partition_pruning=on, pg 11 beta1 on Debian
List pgsql-hackers
Tree view 
On 8 August 2018 at 17:28, Amit Langote <Langote_Amit_f8@lab.ntt.co.jp> wrote:
> Attached is a patch which modifies the if test to compare relids instead
> of RelOptInfo pointers.

Thanks for investigating and writing a patch. I agree with the fix.

It's probably worth writing a test that performs run-time pruning from
an inheritance planner plan.  Do you want to include that in your
patch? If not, I can.

-- 
 David Rowley                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: Temporary tables prevent autovacuum, leading to XID wraparound
Next
From: Christoph Berg
Date:
Subject: Re: pgsql: Fix run-time partition pruning for appends with multiplesource