missing indexes in indexlist with partitioned tables

Arne Roland <a.roland@index.de>

From: Arne Roland <A.Roland@index.de>

To: pgsql-hackers <pgsql-hackers@postgresql.org>

Date: 2021-09-23T17:20:08Z

Lists: pgsql-hackers

Attachments

indexlist_to_late.sql (application/sql)

Hi,


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?


Regards

Arne

Commits

Allow left join removals and unique joins on partitioned tables
- 3c569049b7b5 16.0 landed
Add index on pg_publication_rel.prpubid
- 025b920a3d45 15.0 cited