Date: Tue, 11 May 2021 17:08:43 +0900
From: Michael Paquier <michael@paquier.xyz>
To: Alvaro Herrera <alvherre@alvh.no-ip.org>
Cc: Robert Haas <robertmhaas@gmail.com>, Tom Lane <tgl@sss.pgh.pa.us>,
	Zhihong Yu <zyu@yugabyte.com>,
	PostgreSQL Developers <pgsql-hackers@lists.postgresql.org>
Subject: Re: pgsql: autovacuum: handle analyze for partitioned tables
Message-ID: <YJo7i6oGRr7bRlf0@paquier.xyz>
References: 
 <CA+TgmoaVOx7K0BE8xpR=_FwLGEP1kJoSx+oskCsVGmuJq5h4vw@mail.gmail.com>
 <20210421230649.GA19244@alvherre.pgsql>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha512;
	protocol="application/pgp-signature"; boundary="TdV5wvDfYtggpxWn"
Content-Disposition: inline
In-Reply-To: <20210421230649.GA19244@alvherre.pgsql>
Archived-At: 
 <https://www.postgresql.org/message-id/YJo7i6oGRr7bRlf0%40paquier.xyz>
Precedence: bulk


--TdV5wvDfYtggpxWn
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

On Wed, Apr 21, 2021 at 07:06:49PM -0400, Alvaro Herrera wrote:
> On 2021-Apr-09, Robert Haas wrote:
>> Does this need to worry about new partitions getting attached to a
>> partitioned table, or old ones getting detached? (Maybe it does
>> already, not sure.)
>=20
> I was pinged because this is listed as an open item.  I don't think it
> is one.  Handling ATTACH/DETACH/DROP is important for overall
> consistency, of course, so we should do it eventually, but the fact that
> autovacuum runs analyze *at all* for partitioned tables is an enormous
> step forward from it not doing so.  I think we should treat ATTACH/
> DETACH/DROP handling as a further feature to be added in a future
> release, not an open item to be fixed in the current one.

Yeah, I'd agree that this could be done as some future work so it
looks fine to move it to the section for "won't fix" items, but that
sounds rather tricky to me as there are dependencies across the
partitions.

Now, I don't think that we are completely done either, as one
documentation patch has been sent here:
https://www.postgresql.org/message-id/20210423180152.GA17270@telsasoft.com

Alvaro, could you look at that?
--
Michael

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

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

iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmCaO4sACgkQnvQgOdby
QH1KBBAAoAFldwz57W9bWeZbxOwApQoK1nNl8wdB3tYDTit+nMaNFwvrZL94dD9P
+o7kg4rKslGUGvSxi6og42SgeOssOFOkFUclIV0i3qSlzUJE3GS0bI2VfVbR9FE4
YfMJstaxNXZyNMDksv0UDHxT/OTZO0F1CTwyWYlOnOgno8J0g6qLniURcHsrhXby
YzC8QIK8t+yWUY9Wf0y3yic1rmslN95nJYK4ZxE6yMlp0K8MnxW978qkdiIsFyrj
sEkES8NAhHV51DxjmbnY5D/LGqFIrqcPVwMSu30e3RzY1SU/9FkYQWLOTf4gjp7K
zTcoXE8ZXUqckcuhjG+zvhAcUXBXVcz63ceJlS4eNMYB+HxkBRAFwaO/UGh7azQJ
lws+l2JrcxPfG7P+xUWBVcfJpr0ruXcTwpsa9SlyT6N5bplVXAWbYgsJutkzFGI6
oGwc88FSPq9vihWHxnj7deGBisZN6Dvd5aogYrnxYw31SfOFLEdzIwOWeSm9HvqQ
7jp7E8O4of6jeheWu0vm3RyLDrwQMzAtENmX9HAJcjCmyq7eAptFsYgrlz0zPaUz
8c30/hSLwOe08QdgI34ECKO3SuVt4MhvExxJdClnPCFDPEr+ojZ7q7M+WfjBn7fd
5Mky4nuKFyTczVWBqt+tdx/sY2cqVAg5dzEimnimdhC2FUPbXx8=
=LATy
-----END PGP SIGNATURE-----

--TdV5wvDfYtggpxWn--