vacuumdb --analyze-in-stages

From: "nikolai(dot)berkoff" <nikolai(dot)berkoff(at)pm(dot)me>
To: "pgsql-docs(at)lists(dot)postgresql(dot)org" <pgsql-docs(at)lists(dot)postgresql(dot)org>
Subject: vacuumdb --analyze-in-stages
Date: 2021-10-08 09:33:51
Message-ID: s-kSljtWXMWgMfGTztPTPcS80R8FHdOrBxDTnrQI6GMZbT7au1A4b0fzaSFtKwCI8nwN0MhgPLfVOTvJ7DwTjkip4P3d0o4VgrMJs4OLN-o=@pm.me
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

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.

Attachment Content-Type Size
analyze_in_stages.patch text/x-patch 807 bytes

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message PG Doc comments form 2021-10-08 10:41:13 9.17. Sequence Manipulation Functions
Previous Message nikolai.berkoff 2021-10-08 09:03:34 ALTER TABLE ... SET DATA TYPE removes statistics