Re: vacuumdb changes for stats import/export

From: Frédéric Yhuel <frederic(dot)yhuel(at)dalibo(dot)com>
To: Nathan Bossart <nathandbossart(at)gmail(dot)com>
Cc: Corey Huinker <corey(dot)huinker(at)gmail(dot)com>, Bruce Momjian <bruce(at)momjian(dot)us>, "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, John Naylor <johncnaylorls(at)gmail(dot)com>, Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>, Jeff Davis <pgsql(at)j-davis(dot)com>, jian he <jian(dot)universality(at)gmail(dot)com>, Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Magnus Hagander <magnus(at)hagander(dot)net>, Stephen Frost <sfrost(at)snowman(dot)net>, Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com>, Peter Smith <smithpb2250(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, alvherre(at)alvh(dot)no-ip(dot)org
Subject: Re: vacuumdb changes for stats import/export
Date: 2025-07-28 15:09:15
Message-ID: b527f417-b27c-43bb-8623-4c703fc0ad72@dalibo.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 7/28/25 16:47, Nathan Bossart wrote:
> I can't remember who wrote this line, but it was borrowed from the
> --analyze-in-stages description. The point is that if you use
> --analyze-in-stages without --missing-stats-only, there will be a period
> where existing statistics will be replaced with ones generated with lower
> statistics targets.

Aha, it makes sense now, thank you!

> Obviously, this wording isn't clear enough. We might
> need to either remove that sentence or add "When used in conjunction with
> --analyze-in-stages..."

I vote for the second option.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jean-Christophe Arnu 2025-07-28 15:18:59 Re: restore_command return code behaviour
Previous Message Tom Lane 2025-07-28 14:54:51 Making pgfdw_report_error statically analyzable