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 1tTiTG-008sI9-BU for pgsql-hackers@arkaria.postgresql.org; Fri, 03 Jan 2025 14:16:14 +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 1tTiTF-002655-Mt for pgsql-hackers@arkaria.postgresql.org; Fri, 03 Jan 2025 14:16:13 +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 1tTiTF-00264u-Ay for pgsql-hackers@lists.postgresql.org; Fri, 03 Jan 2025 14:16:13 +0000 Received: from mail-io1-xd35.google.com ([2607:f8b0:4864:20::d35]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tTiTC-0002VW-1G for pgsql-hackers@postgresql.org; Fri, 03 Jan 2025 14:16:12 +0000 Received: by mail-io1-xd35.google.com with SMTP id ca18e2360f4ac-844d555491eso419888739f.0 for ; Fri, 03 Jan 2025 06:16:08 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1735913767; x=1736518567; darn=postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=oP4OkehSWeCpxqXPpcWjnTWqhPsUGrFKGUeUbcflZAk=; b=MyokaULeV8uycxP7HNmqD6iTGG03wX4xPybYS2Z90gBQ7bL4seb4m9Z9W7d5u1nGNG ACJEeqouhQrcdSvbYrvYfThT3cCasKPvhMcdQ86ce8JuujxPjHW+Mpn1d+NV6ONS7B12 UFtUEBA30dz/PKBlEj00Oy5WwjL2mLo/s1RDu18mkvLwA/bonxqE1a3g1mCE5oMa4RWx PzljX0t8K/mCZB2RRe4oNbNAv8/x/oPrVvg3p00VA3tcuF0zNJxBqGGFm7FRHbrbpZVl Bp6cjbZ/cJk7oPN6lxGCNYl7N+JG2+vdSgA+1T1hAq1x/iL54ICJGUM400PxxdrHtYpO xgNw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1735913767; x=1736518567; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=oP4OkehSWeCpxqXPpcWjnTWqhPsUGrFKGUeUbcflZAk=; b=iWzoDPMD4+DPmHGDzM3atUsvJZPJJ40ZsI8hi0egeNoM5YFK6O4l8zAGo56sB8oblQ YmvDhLRiuIQkpS0+AuqMOcpeXDWWZf+zA8wrINSEaYvI8orRoB1M1WmNSl5EOgYWZCZH k1YTg3aZucZW7VBVQ+lZTyVZCytPlRNdZ/r5/cOEGKkKz0VXOCnXTi94wCUBQ0Zyo28c ZpizuiKsbEyAEL4EJeZ/Go2QxPE4D0VdiuIrLZKhEY/Abxe60iv3i0/obXbTJ4TF4E/P 0XnpWyOd4TLJneRB1INtbqvB598sXpAdXSpzrUMXyq638cX2p2ApbuzbeNJZ2Yg/y9ml O+Sw== X-Forwarded-Encrypted: i=1; AJvYcCVNG1Ijadm0dMq490dAcxjp5rxdEFiupenfAGKERP9DDWLSJSYxqTfXClH8xhFZG9D+12X0Iq0ik/owj1uX@postgresql.org X-Gm-Message-State: AOJu0YwbYdAOUQjXCIpHzr5yVWboCRtr5UkwTXNb+TM1nPG43QEVHNiZ 5RSpNyWztnrt6AoNvnM9Y5My7dXscgSNyNeuvEguLg2oQfpEb01EL7IxfMZfVLREKYv0N+kmC3n 1TSwaK/1vt5fFopTaU5AhajE1ku0= X-Gm-Gg: ASbGncu9QLGzfJm/U/64u8fXt8yQ4IShX1a0cWRt/GseEUskheqfUd/j0qVxIQpLTEG +8hCE3dVSCR/s9Lo8hHHHZUvbFot8xscEKcP3MA== X-Google-Smtp-Source: AGHT+IG9WJvsXRuKmwT9htQ+fnmo4DCoN5Guo7ClL9Nn06i73VCCNwYWio4ouLCctdsH4Pekc/KCwuiXJ5JIC5nIFgY= X-Received: by 2002:a05:6e02:1645:b0:3ab:8db6:12ac with SMTP id e9e14a558f8ab-3c2d1b9c925mr357455555ab.4.1735913767378; Fri, 03 Jan 2025 06:16:07 -0800 (PST) MIME-Version: 1.0 References: <9b10c6d3-52c4-4eef-b67c-c33442667729@postgrespro.ru> <9485d892-fd04-4e3a-ac24-7dd767cb7333@postgrespro.ru> <0B6CBF4C-CC2A-4200-9126-CE3A390D938B@upgrade.com> <6732acf8ce0f31025b535ae1a64568750924a887.camel@moonset.ru> <5AA8FFD5-6DE2-4A31-8E00-AE98F738F5D1@upgrade.com> <85b963fe-5977-43aa-9241-75b862abcc69@postgrespro.ru> <9C7A167C-DCDE-4A17-9ABE-6276723FEC50@upgrade.com> <2d493cf9-9ba7-4cc1-a3f2-67afd7c163ee@postgrespro.ru> <77e6e723-0d3e-4235-8386-03d143916125@postgrespro.ru> <0E5557BC-50FC-400F-BE96-11922C0C11EE@upgrade.com> In-Reply-To: <0E5557BC-50FC-400F-BE96-11922C0C11EE@upgrade.com> From: Greg Sabino Mullane Date: Fri, 3 Jan 2025 09:15:30 -0500 Message-ID: Subject: Re: Vacuum statistics To: Jim Nasby Cc: Sami Imseih , Alena Rybakina , Ilia Evdokimov , Andrei Zubkov , Masahiko Sawada , Melanie Plageman , jian he , pgsql-hackers , a.lepikhov@postgrespro.ru, Alexander Korotkov Content-Type: multipart/alternative; boundary="0000000000007729e6062acdeb99" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000007729e6062acdeb99 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable > > While backwards compatibility is important, there=E2=80=99s definitely pr= ecedent > for changing what shows up in the catalog. IMHO it=E2=80=99s better to bi= te the > bullet and move those fields instead of having vacuum stats spread across > two different views. > -1. That's a huge change, and pg_stat_all_tables is used way, way more than things like pg_stat_bgwriter. Cheers, Greg --0000000000007729e6062acdeb99 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
While backwards compatibility= is important, there=E2=80=99s definitely precedent for changing what shows= up in the catalog. IMHO it=E2=80=99s better to bite the bullet and move th= ose fields instead of having vacuum stats spread across two different views= .

-1. That's a huge change, and p= g_stat_all_tables is used way, way more than things like pg_stat_bgwriter.<= /div>

Cheers,
Greg

= =C2=A0
--0000000000007729e6062acdeb99--