missing indexes in indexlist with partitioned tables

From: Arne Roland <A(dot)Roland(at)index(dot)de>
To: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: missing indexes in indexlist with partitioned tables
Date: 2021-09-23 17:20:08
Message-ID: c3b2408b7a39433b8230bbcd02e9f302@index.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers


I did a bit of testing today and noticed that we don't set indexlist properly 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?



Attachment Content-Type Size
indexlist_to_late.sql application/sql 296 bytes


Browse pgsql-hackers by date

  From Date Subject
Next Message Matthias van de Meent 2021-09-23 18:18:41 Re: CLUSTER on partitioned index
Previous Message Robert Haas 2021-09-23 17:06:06 Re: Release 14 Schedule