Re: 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: Re: missing indexes in indexlist with partitioned tables
Date: 2021-10-28 13:44:31
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers


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!


Attachment Content-Type Size
partIndexlistClean.patch text/x-patch 64.2 KB

In response to


Browse pgsql-hackers by date

  From Date Subject
Next Message Ronan Dunklau 2021-10-28 13:55:12 Re: pg_receivewal starting position
Previous Message David Steele 2021-10-28 13:08:38 Re: Allow root ownership of client certificate key