Re: vacuumdb --analyze-in-stages - Mailing list pgsql-docs

From Euler Taveira
Subject Re: vacuumdb --analyze-in-stages
Date
Msg-id c34d7d46-ef28-4fd2-84bb-7d38b039aae9@www.fastmail.com
Whole thread Raw
In response to vacuumdb --analyze-in-stages  ("nikolai.berkoff" <nikolai.berkoff@pm.me>)
Responses Re: vacuumdb --analyze-in-stages  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
List pgsql-docs
On Fri, Oct 8, 2021, at 6:33 AM, nikolai.berkoff wrote:
Running --analyze-in-stages on a database with statistics causes the statistics to become significantly worse before they are improved.  This could be made clearer in the documentation.
I think the paragraph you modified *already* stated that usefulness of
--analyze-in-stages (newly populated from a restored dump or by pg_upgrade). I
don't think your change is an improvement for --analyze-in-stages description.
If you read the previous paragraph, it explains _how_ (3 stages of ANALYZE with
different settings) and _why_ (produce usable statistics faster).


--
Euler Taveira

pgsql-docs by date:

Previous
From: PG Doc comments form
Date:
Subject: pmap grep zero fail to load vm_peak
Next
From: "Euler Taveira"
Date:
Subject: Re: ALTER TABLE ... SET DATA TYPE removes statistics