Message-ID: <e9f3d991b8820fd1e076367b20709a1be2558227.camel@cybertec.at>
Subject: Re: Disabling vacuum truncate for autovacuum
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Nathan Bossart <nathandbossart@gmail.com>, Fujii Masao
	 <masao.fujii@oss.nttdata.com>
Cc: Gurjeet Singh <gurjeet@singh.im>, Robert Haas <robertmhaas@gmail.com>, 
 Postgres Hackers <pgsql-hackers@postgresql.org>, Will Storey
 <will@summercat.com>
Date: Fri, 14 Mar 2025 22:01:09 +0100
In-Reply-To: <Z9ROT9v4rHjDYWNX@nathan>
References: <Z2DE4lDX4tHqNGZt@dev.null>
	 <fa83a77bbca5da4d4864a49c8a27df323f23d28b.camel@cybertec.at>
	 <CABwTF4U3xkF=ZRi2pztUDxohoN8h6XL10=QmTtuTXoMjzu5-zg@mail.gmail.com>
	 <f82fc7fbb69a8c8000ad74ced50381257fe57838.camel@cybertec.at>
	 <CA+TgmoZMXN19eorKdeiiFCv3AJFVaUAfkzRuamnt8A9U8uJSqg@mail.gmail.com>
	 <Z7Tl2d7HrG1AQEOc@nathan>
	 <CABwTF4XPc1_y=khhjErd=Oz8R20ZH05KigiAnMjjA+028QbohQ@mail.gmail.com>
	 <Z8H-tHaYZ37lVZHb@nathan>
	 <28773a66-fb88-41cf-a7ec-4216e6c91c94@oss.nttdata.com>
	 <Z9ROT9v4rHjDYWNX@nathan>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.54.3 (3.54.3-1.fc41) 
MIME-Version: 1.0
Archived-At: <https://www.postgresql.org/message-id/e9f3d991b8820fd1e076367b20709a1be2558227.camel%40cybertec.at>
Precedence: bulk

On Fri, 2025-03-14 at 10:42 -0500, Nathan Bossart wrote:
> One other difference in my version of the patch [0] is to call this GUC
> vacuum_truncate and have it apply to both autovacuum and VACUUM.

I agree that that is the way to go.
It makes no sense to restrict the feature to autovacuum.

Yours,
Laurenz Albe