Content-Type: text/plain;
	charset=utf-8
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3774.500.171.1.1\))
Subject: Re: Request for feature: VACUUM FULL updates
 pg_stat_all_tables.last_vacuum
From: Scott Ribe <scott_ribe@elevated-dev.com>
In-Reply-To: 
 <CAKFQuwbhDpOwB25TAEhcE9gTf8UK_aei98pae5Q0yBWLaO=KWQ@mail.gmail.com>
Date: Thu, 9 May 2024 09:12:31 -0600
Cc: Ron Johnson <ronljohnsonjr@gmail.com>,
 Pgsql-admin <pgsql-admin@lists.postgresql.org>
Content-Transfer-Encoding: quoted-printable
Message-Id: <1F345CC7-6A59-4324-B6D2-BDC80B96182F@elevated-dev.com>
References: 
 <CANzqJaBDOrzCsd-hp15ya6JEScgqWYUhN5xUZBsUqZxWv9p6DQ@mail.gmail.com>
 <CAKFQuwbzX+KiHgyCS=8DpVgaTu1H9hjOTO7THK=cH=+vxnuzYA@mail.gmail.com>
 <CANzqJaB9BTg2G7qJV=qz=sdQgpBvZB8H7xcHvzm_dUy7wccdtg@mail.gmail.com>
 <CAKFQuwbhDpOwB25TAEhcE9gTf8UK_aei98pae5Q0yBWLaO=KWQ@mail.gmail.com>
To: "David G. Johnston" <david.g.johnston@gmail.com>
Archived-At: 
 <https://www.postgresql.org/message-id/1F345CC7-6A59-4324-B6D2-BDC80B96182F%40elevated-dev.com>
Precedence: bulk

> On May 9, 2024, at 8:49=E2=80=AFAM, David G. Johnston =
<david.g.johnston@gmail.com> wrote:
>=20
> Why?  RECREATE TABLE says exactly what it does: recreates the table, =
and doesn't pretend to do something it doesn't do (vacuum the table).

The current method is just one alternative to implement the goal: =
removing all dead tuples. Exposing the implementation detail in the =
command name is not really any kind of improvement, IMO.