Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1t122D-00ENwz-Je for pgsql-hackers@arkaria.postgresql.org; Wed, 16 Oct 2024 11:17:45 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1t122B-00207D-L7 for pgsql-hackers@arkaria.postgresql.org; Wed, 16 Oct 2024 11:17:44 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1t122B-002074-BU for pgsql-hackers@lists.postgresql.org; Wed, 16 Oct 2024 11:17:43 +0000 Received: from relay164.nicmail.ru ([91.189.117.8]) by magus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1t1229-001LHB-L6 for pgsql-hackers@postgresql.org; Wed, 16 Oct 2024 11:17:43 +0000 Received: from [10.28.136.255] (port=9508 helo=localhost) by relay.hosting.mail.nic.ru with esmtp (Exim 5.55) (envelope-from ) id 1t1227-000000004B9-8lQ8; Wed, 16 Oct 2024 14:17:39 +0300 Received: from [78.107.250.17] (account zubkov@moonset.ru HELO localhost) by incarp1105.mail.hosting.nic.ru (Exim 5.55) with id 1t1227-009lWX-0M; Wed, 16 Oct 2024 14:17:39 +0300 Received: from [192.168.61.161] by localhost with esmtpsa (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1t1226-0006mA-ET; Wed, 16 Oct 2024 14:17:38 +0300 Message-ID: Subject: Re: Vacuum statistics From: Andrei Zubkov To: Ilia Evdokimov , Alena Rybakina , pgsql-hackers Cc: jian he , Alexander Korotkov , Alena Rybakina , a.lepikhov@postgrespro.ru Date: Wed, 16 Oct 2024 14:17:38 +0300 In-Reply-To: <1a960398-d12d-419a-af48-4acfe58d0c3a@tantorlabs.com> References: <53c47c2d-72a5-44f2-900c-9973b2af1808@tantorlabs.com> <4a902cea-54fb-41b5-b208-b84731a5f577@postgrespro.ru> <092adec6-4eae-4bd4-bd0d-473a9df1282b@tantorlabs.com> <3deae1bd-ad84-4459-a26e-04c9136b84e9@postgrespro.ru> <9b10c6d3-52c4-4eef-b67c-c33442667729@postgrespro.ru> <30e2e941-b9f6-4ea1-aa3b-f0c406b8797d@postgrespro.ru> <1a960398-d12d-419a-af48-4acfe58d0c3a@tantorlabs.com> Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.46.4-2 MIME-Version: 1.0 X-MS-Exchange-Organization-SCL: -1 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi Ilia, On Wed, 2024-10-16 at 13:31 +0300, Ilia Evdokimov wrote: > BTW,=C2=A0I recommend renaming the view pg_stat_vacuum_database to > pg_stat_vacuum_databaseS=C2=A0 for consistency with pg_stat_vacuum_tables > and pg_stat_vacuum_indexes Such renaming doesn't seems correct to me because pg_stat_vacuum_database is consistent with pg_stat_database view, while pg_stat_vacuum_tables is consistent with pg_stat_all_tables. This inconsistency is in Postgres views, so it should be changed synchronously. --=20 regards, Andrei Zubkov