Re: Internal error XX000 with enable_partition_pruning=on, pg 11 beta1 on Debian

David Rowley <david.rowley@2ndquadrant.com>

From: David Rowley <david.rowley@2ndquadrant.com>

To: Tom Lane <tgl@sss.pgh.pa.us>

Cc: Robert Haas <robertmhaas@gmail.com>, Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>, Phil Florent <philflorent@hotmail.com>, PostgreSQL Hackers <pgsql-hackers@postgresql.org>

Date: 2018-08-01T14:42:18Z

Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Match RelOptInfos by relids not pointer equality.
- a3deecb1c9af 11.0 landed
- 11e22e486d8d 12.0 landed
Fix run-time partition pruning for appends with multiple source rels.
- 1b54e91faabf 11.0 landed
- 1c2cb2744bf3 12.0 landed

Attachments

remove_incorrect_partprune_assert.patch (application/octet-stream) patch

On 20 July 2018 at 01:03, David Rowley <david.rowley@2ndquadrant.com> wrote:
> I've attached a patch intended for master which is just v2 based on
> post 5220bb7533.

In [1] I mentioned that I think that bug should be fixed as part of
this bug fix too. It just seems a little strange to fix that one
separately when without the v3 patch for this fix the code still won't
work correctly when any subplans are present which don't belong in the
partition hierarchy.

I've attached a patch which can be applied on top of the v3 patch.

[1] https://www.postgresql.org/message-id/CAKJS1f9e7hHYP9SaT%3D-_RR4jdmm9VCgtDoC3-60s97EMjcfGWg%40mail.gmail.com

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