postgresql – Need help in using the analyze-in-stages option of the vacuumdb command

postgresql – Need help in using the analyze-in-stages option of the vacuumdb command

I have found an answer looking into the history of code : vacuumdb: Add option –analyze-in-stages

There are indeed 3 stages using this parameters :

  1. minimal : SET default_statistics_target=1; SET vacuum_cost_delay=0;
  2. medium : SET default_statistics_target=10; RESET vacuum_cost_delay;
  3. default (full) : RESET default_statistics_target;

ref. diff vacuumdb.c

postgresql – Need help in using the analyze-in-stages option of the vacuumdb command

Leave a Reply

Your email address will not be published. Required fields are marked *