From: | Phil Florent <philflorent(at)hotmail(dot)com> |
---|---|
To: | David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Robert Haas <robertmhaas(at)gmail(dot)com>, "Amit Langote" <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | RE: Internal error XX000 with enable_partition_pruning=on, pg 11 beta1 on Debian |
Date: | 2018-07-16 08:03:51 |
Message-ID: | DB7PR03MB4730826F8ACCF1F643EED319BA5D0@DB7PR03MB4730.eurprd03.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
I get it. Thank you for this precision.
Regards
Phil
________________________________
De : David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>
Envoyé : lundi 16 juillet 2018 07:48
À : Phil Florent
Cc : Tom Lane; Robert Haas; Amit Langote; PostgreSQL Hackers
Objet : Re: Internal error XX000 with enable_partition_pruning=on, pg 11 beta1 on Debian
On 16 July 2018 at 16:56, Phil Florent <philflorent(at)hotmail(dot)com<mailto:philflorent(at)hotmail(dot)com>> wrote:
I should post that in the general section but I am confused by the sentence "A parent partition is always going to have a lower relid than its children"
It's a little confusing since RelOptInfo has a relid field and so does RangeTblEntry. They both have completely different meanings. RelOptInfo's relid is a number starting at 1 and continues in a gapless sequence increasing by 1 with each RelOptInfo. These relids are completely internal to the server and don't appear in the system catalog tables. RangeTblEntry's relid is what's in pg_class.oid.
I was talking about RelOptInfo's relid.
Using relids starting at 1 is quite convenient for allowing direct array lookups in various data structures in the planner. However it's also required to uniquely identify a relation as a single table may appear many times in a query, so trying to identify them by their oid could be ambiguous. Also, some RTEKinds don't have storage, e.g a VALUES() clause.
--
David Rowley http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
From | Date | Subject | |
---|---|---|---|
Next Message | Haribabu Kommi | 2018-07-16 08:14:57 | Re: Libpq support to connect to standby server as priority |
Previous Message | Fabien COELHO | 2018-07-16 07:53:55 | Re: Make foo=null a warning by default. |