Message-ID: <4b94ca16-7a6d-4581-b2aa-4ea79dbc082a@dalibo.com>
Date: Wed, 23 Jul 2025 14:45:10 +0200
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: vacuumdb changes for stats import/export
To: Nathan Bossart <nathandbossart@gmail.com>,
 Corey Huinker <corey.huinker@gmail.com>
Cc: John Naylor <johncnaylorls@gmail.com>,
 Masahiko Sawada <sawada.mshk@gmail.com>, Bruce Momjian <bruce@momjian.us>,
 Jeff Davis <pgsql@j-davis.com>, jian he <jian.universality@gmail.com>,
 Matthias van de Meent <boekewurm+postgres@gmail.com>,
 Tom Lane <tgl@sss.pgh.pa.us>, Magnus Hagander <magnus@hagander.net>,
 Stephen Frost <sfrost@snowman.net>,
 Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>,
 Peter Smith <smithpb2250@gmail.com>,
 PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>,
 alvherre@alvh.no-ip.org
References: 
 <CANWCAZacHEinN0tYUwHahzeJguDoannP0Nksv9LnLPpFD2kb+g@mail.gmail.com>
 <Z8oX2u2Db8x2Y1za@nathan>
 <CANWCAZa3tOfy2t7PraGh7td0nuO8rLesE8Cp2D1QZ+vM0hRcxg@mail.gmail.com>
 <Z88AgUXOR3e3ZsDV@nathan> <Z9BsEfqEmwkUetgz@nathan>
 <CANWCAZbiLHGeAZPYg6G6eT6MmCXM7CuYBEj3WhWw76e_HQejDA@mail.gmail.com>
 <Z9HhrtaZyFgMvJsM@nathan> <Z9R9-mFbxukqKmg4@nathan> <Z9jXuyymBSVDw9pv@nathan>
 <CADkLM=ek625v06WeeOpUNjGnCqyD8pH_0iYcCpg57KP3A8D9qg@mail.gmail.com>
 <Z9nnsPBlBzWxDuLi@nathan>
From: =?UTF-8?Q?Fr=C3=A9d=C3=A9ric_Yhuel?= <frederic.yhuel@dalibo.com>
Content-Language: fr, en-US
Autocrypt: addr=frederic.yhuel@dalibo.com; keydata=
 xjMEXn3bgxYJKwYBBAHaRw8BAQdA6tX5FT/n5ztMWIoBdl6k5avvu65fv6ryfVzIx/aH3V3N
 JEYuIFlodWVsIDxmcmVkZXJpYy55aHVlbEBkYWxpYm8uY29tPsKWBBMWCAA+FiEEi7OTyf6H
 ePS+C6n11XGWhN8zGNUFAmZDVJ8CGwMFCQtfi90FCwkIBwIGFQoJCAsCBBYCAwECHgECF4AA
 CgkQ1XGWhN8zGNV65gEA6o+UrebFjn2CIAOYwP3CiiJugiM5TMH9yJyehQua5ZoA/2ChxiVn
 8OUaAw/ErxJmQi1mSN0tNZBL/KhkUPBDUDQNzjgEXn3bgxIKKwYBBAGXVQEFAQEHQCuh5cLQ
 AtEBXHa2Fmtp0kduBu7msM7qO/gaEcdjFUdiAwEIB8J+BBgWCAAmAhsMFiEEi7OTyf6HePS+
 C6n11XGWhN8zGNUFAmZDVJ8FCQtfi90ACgkQ1XGWhN8zGNWOOAEArSqePBqfd4Kx4ulACaWO
 6fM+XSDfUlBAQXx9rU6DR4MBALwozl9g91tRysim6lKxggvBfp/PvbpTZNrxYLWB2fYP
In-Reply-To: <Z9nnsPBlBzWxDuLi@nathan>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Archived-At: 
 <https://www.postgresql.org/message-id/4b94ca16-7a6d-4581-b2aa-4ea79dbc082a%40dalibo.com>
Precedence: bulk


On 3/18/25 22:37, Nathan Bossart wrote:
> Committed with the following small changes:

Hi, I don't really understand this sentence in 
doc/src/sgml/ref/vacuumdb.sgml:

 > This option prevents vacuumdb from deleting existing statistics so 
that the query optimizer's choices do not become transiently worse.

I thought that the point was to avoid unnecessary post-upgrade analyzes?