Feedback-ID: i0fe9450f:Fastmail
Date: Mon, 8 Dec 2025 08:29:12 +0900
From: Michael Paquier <michael@paquier.xyz>
To: =?iso-8859-1?Q?=C1lvaro?= Herrera <alvherre@kurilemu.de>
Cc: Mihail Nikalayeu <mihailnikalayeu@gmail.com>,
	Alexander Lakhin <exclusion@gmail.com>,
	Noah Misch <noah@leadboat.com>,
	PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Subject: Re: Issues with ON CONFLICT UPDATE and REINDEX CONCURRENTLY
Message-ID: <aTYNyPELpDeNAHLc@paquier.xyz>
References: 
 <CADzfLwUyKoTES1D7TBWqkYJF+82Gcvy+tcsDpW0OLSiCbadwkQ@mail.gmail.com>
 <202512072050.hcyysny65ugj@alvherre.pgsql>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha512;
	protocol="application/pgp-signature"; boundary="AMYYrbmPTfkxErRH"
Content-Disposition: inline
In-Reply-To: <202512072050.hcyysny65ugj@alvherre.pgsql>
Archived-At: 
 <https://www.postgresql.org/message-id/aTYNyPELpDeNAHLc%40paquier.xyz>
Precedence: bulk


--AMYYrbmPTfkxErRH
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline

On Sun, Dec 07, 2025 at 10:07:45PM +0100, Alvaro Herrera wrote:
> Hmm, as I recall it's quite intentional that the index on a partitioned
> table is marked !indisvalid; such indexes are only supposed to be marked
> valid once indexes on all partitions have been attached.  As I recall,
> if you remove that prohibition, some pg_dump scenarios fail.

Right.  If indisvalid is true on a partitioned table, then we are sure
that all its partitions have valid indexes.  If indisvalid is false,
some of its partitions may have an invalid index.  In the false case,
things can be a bit lossy as well.  For example, an ALTER TABLE ONLY
could switch a partition's indisvalid to be true, without switching to
true the indisvalid of its partitioned table.
--
Michael

--AMYYrbmPTfkxErRH
Content-Type: application/pgp-signature; name="signature.asc"

-----BEGIN PGP SIGNATURE-----

iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmk2DcgACgkQnvQgOdby
QH3Q4g//ecR9chmVNxBHzgYfmOqVDSnP/g0Z2fEOXPm7gCaye3IwjGhvbhzDqT3R
UJVtKjzYU3NI6Sg8PuxabhQUsNWtvcQ9NfWc3kpb5Z/pf+QrUerJb331kLTUYvQR
Od/+m4fyhId/BtVjzVuRaBWVbocg46JUJotVva59CcE1Mo+I4+eYcBawWvfpvGGF
uwEouwg3ZQe9gpED+LQUcRudWYmsfbE43WiQ6MI0510P6uTwX2wO/JEjhqQnY1uA
WEzb3f6MV85R65KjMMOkHq1spM/m+B1y0sombMxUoYYwvMlkC60/B2vLxmD8y6Of
Q7AkJWYSHku97Xxf5+6cpMsRxG71mQxOjNTd2ttySxVFwKEMnlOfczwskPLXuy6o
EmTaPOkwoaHdsr2aKPXn9wsu0N0tnHpLNYTVVP8UDWxwZszipzT6DpNZiadW/l3+
8mWrEgFKaKRXJWxaT1W3/zRcJ9Psf+yns1LJHNS3sX+bDkaE1eUl4MI6Z2p4aRZ6
gWpr1ET1pIaZ7lh5XHuGF96idh+Rpd+H859nysT61ju4Z+8LmlFV0J6781SaDwdR
9e9VmlLui/gyyQFugRHwDELQU5eyGKYSz35rWtyllskU9gL0jYEmHCM3iCfh2Bdc
M5AVjrbMJb7rIpNM3Q33JclzKXTKv3IOF5tISAq3LsBiGMFmjRs=
=hvtc
-----END PGP SIGNATURE-----

--AMYYrbmPTfkxErRH--