Re: [PATCH] Fix: Partitioned parent index remains invalid after child indexes are repaired - Mailing list pgsql-hackers

From Sami Imseih
Subject Re: [PATCH] Fix: Partitioned parent index remains invalid after child indexes are repaired
Date
Msg-id CAA5RZ0uM7_YPdSahGh1sGeewMb9SzKswyLaZty8aR+a7XpQydQ@mail.gmail.com
Whole thread
In response to Re: [PATCH] Fix: Partitioned parent index remains invalid after child indexes are repaired  (Michael Paquier <michael@paquier.xyz>)
List pgsql-hackers
Hi,

> Could you write a patch?  It would be better to have tests with
> multiple levels, at least, with a partitioned table being a leaf of
> another partitioned table.  I am sure you get the picture, the point
> being to recurse across multiple levels.

Here is the patch with tests. It adds a test for this case using
multi-level partitions and ensures that the parent indexes are
validated once a child index is set to valid. Also, I added the
negative case where only one child index is validated to ensure
that the parent indexes remain invalid.

--
Sami Imseih
Amazon Web Services (AWS)

Attachment

pgsql-hackers by date:

Previous
From: Mihail Nikalayeu
Date:
Subject: Re: Resetting snapshots during the first phase of [CREATE |RE]INDEX CONCURRENTLY
Next
From: Alexander Lakhin
Date:
Subject: Re: eliminate xl_heap_visible to reduce WAL (and eventually set VM on-access)