Re: 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-10-28T13:44:31Z
Lists: pgsql-hackers
Attachments
- partIndexlistClean.patch (text/x-patch) patch
Hi, I stumbled across a few places that depend on the inheritance appends being applied at a later date, so I quickly abandoned that idea. I thought a bit about the indexlist, in particular the inhparent, and I am not sure what depends on get_relation_info working in that way. Therefore I propose a new attribute partIndexlist of RelOptInfo to include information about uniqueness, in the case the executor can't use the structure that causes the uniqueness to begin with. Said attribute can be used by relation_has_unique_index_for and rel_supports_distinctness. The attached patch takes that route. I'd appreciate feedback! 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