| 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 |
| Message-ID: | fa4168b2f72e44939e66f297037b9be9@index.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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
| Attachment | Content-Type | Size |
|---|---|---|
| partIndexlistClean.patch | text/x-patch | 64.2 KB |
| 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 |