From: Arne Roland <A.Roland@index.de>
To: pgsql-hackers <pgsql-hackers@postgresql.org>
Subject: missing indexes in indexlist with partitioned tables
Thread-Topic: missing indexes in indexlist with partitioned tables
Thread-Index: AQHXsJoeXw6ojQG4NkOLdiX4KUBdDw==
Date: Thu, 23 Sep 2021 17:20:08 +0000
Message-ID: <c3b2408b7a39433b8230bbcd02e9f302@index.de>
Accept-Language: en-US, de-DE
Content-Language: en-US
Content-Type: multipart/mixed;
	boundary="_004_c3b2408b7a39433b8230bbcd02e9f302indexde_"
MIME-Version: 1.0
Archived-At: 
 <https://www.postgresql.org/message-id/c3b2408b7a39433b8230bbcd02e9f302%40index.de>
Precedence: bulk

--_004_c3b2408b7a39433b8230bbcd02e9f302indexde_
Content-Type: multipart/alternative;
	boundary="_000_c3b2408b7a39433b8230bbcd02e9f302indexde_"

--_000_c3b2408b7a39433b8230bbcd02e9f302indexde_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi,


I did a bit of testing today and noticed that we don't set indexlist proper=
ly at the right time in some cases when using partitioned tables.


I attached a simple case where the indexlist doesn't seems to be set at the=
 right time. get_relation_info in plancat.c seems to process it only after =
analyzejoins.c checked for it.


Can someone explain to me why it is deferred at all?


Regards

Arne


--_000_c3b2408b7a39433b8230bbcd02e9f302indexde_
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<html>
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Diso-8859-=
1">
<style type=3D"text/css" style=3D"display:none;"><!-- P {margin-top:0;margi=
n-bottom:0;} --></style>
</head>
<body dir=3D"ltr">
<div id=3D"divtagdefaultwrapper" style=3D"font-size:12pt;color:#000000;font=
-family:Calibri,Helvetica,sans-serif;" dir=3D"ltr">
<p>Hi,</p>
<p><br>
</p>
<p>I did a bit of testing today and noticed that we don't set <span>indexli=
st</span> properly at the right time in some cases when using partitioned t=
ables.</p>
<p><br>
</p>
<p>I attached a simple case where the indexlist doesn't seems to be set at =
the right time.
<span>get_relation_info in <span>plancat.c</span></span> seems to process i=
t only after
<span class=3D"comment">analyzejoins.c</span> checked for it.</p>
<p><br>
</p>
<p>Can someone explain to me why it is deferred at all?</p>
<p><br>
</p>
<p>Regards</p>
<p>Arne</p>
<p><br>
</p>
</div>
</body>
</html>

--_000_c3b2408b7a39433b8230bbcd02e9f302indexde_--

--_004_c3b2408b7a39433b8230bbcd02e9f302indexde_
Content-Type: application/sql; name="indexlist_to_late.sql"
Content-Description: indexlist_to_late.sql
Content-Disposition: attachment; filename="indexlist_to_late.sql"; size=296;
	creation-date="Thu, 23 Sep 2021 17:17:33 GMT";
	modification-date="Thu, 23 Sep 2021 17:17:33 GMT"
Content-Transfer-Encoding: base64

Y3JlYXRlIHRhYmxlIHB1YmxpYy5hIChpZCBiaWdpbnQgbm90IG51bGwgcHJpbWFyeSBrZXkpIHBh
cnRpdGlvbiBieSByYW5nZSAoaWQpOwpjcmVhdGUgdGFibGUgYiBwYXJ0aXRpb24gb2YgYSBmb3Ig
dmFsdWVzIGZyb20gKDApIHRvICgxMDAwKTsKCi0tIHdvcmtzIGFzIGV4cGVjdGVkCmV4cGxhaW4g
c2VsZWN0IGEuaWQgZnJvbSBhIGxlZnQgam9pbiBiIHVzaW5nIChpZCk7Ci0tIGluZGV4bGlzdCBp
cyBzZXQgdG8gbGF0ZQpleHBsYWluIHNlbGVjdCBhLmlkIGZyb20gYSBsZWZ0IGpvaW4gYSBhMSB1
c2luZyAoaWQpOwo=

--_004_c3b2408b7a39433b8230bbcd02e9f302indexde_--