pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Frédéric Yhuel <frederic.yhuel@dalibo.com>
To: Nathan Bossart <nathandbossart@gmail.com>
To: Corey Huinker <corey.huinker@gmail.com>
Cc: John Naylor <johncnaylorls@gmail.com>
Cc: Masahiko Sawada <sawada.mshk@gmail.com>
Cc: Bruce Momjian <bruce@momjian.us>
Cc: Jeff Davis <pgsql@j-davis.com>
Cc: jian he <jian.universality@gmail.com>
Cc: Matthias van de Meent <boekewurm+postgres@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Magnus Hagander <magnus@hagander.net>
Cc: Stephen Frost <sfrost@snowman.net>
Cc: Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>
Cc: Peter Smith <smithpb2250@gmail.com>
Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Cc: alvherre@alvh.no-ip.org
Subject: Re: vacuumdb changes for stats import/export
Date: Wed, 23 Jul 2025 14:45:10 +0200
Message-ID: <4b94ca16-7a6d-4581-b2aa-4ea79dbc082a@dalibo.com> (raw)
In-Reply-To: <Z9nnsPBlBzWxDuLi@nathan>
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>



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?





view thread (36+ messages)  latest in thread

Message-ID: <4b94ca16-7a6d-4581-b2aa-4ea79dbc082a@dalibo.com>
Permalink:  ../4b94ca16-7a6d-4581-b2aa-4ea79dbc082a@dalibo.com/
Also on:    postgresql.org/message-id/4b94ca16-7a6d-4581-b2aa-4ea79dbc082a@dalibo.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-hackers@postgresql.org
  Cc: frederic.yhuel@dalibo.com, nathandbossart@gmail.com, corey.huinker@gmail.com, johncnaylorls@gmail.com, sawada.mshk@gmail.com, bruce@momjian.us, pgsql@j-davis.com, jian.universality@gmail.com, boekewurm+postgres@gmail.com, tgl@sss.pgh.pa.us, magnus@hagander.net, sfrost@snowman.net, ashutosh.bapat.oss@gmail.com, smithpb2250@gmail.com, pgsql-hackers@lists.postgresql.org, alvherre@alvh.no-ip.org
  Subject: Re: vacuumdb changes for stats import/export
  In-Reply-To: <4b94ca16-7a6d-4581-b2aa-4ea79dbc082a@dalibo.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox