vacuumdb --all --analyze-in-stages - wrong order? - Mailing list pgsql-hackers

From Pavel Stehule
Subject vacuumdb --all --analyze-in-stages - wrong order?
Date
Msg-id CAFj8pRB-Ay_uC2oMdzR8p_jJoOi-Rbr1a8k9YMLRz6dY-QGnnA@mail.gmail.com
Whole thread Raw
Responses Re: vacuumdb --all --analyze-in-stages - wrong order?
List pgsql-hackers
Hello

I am looking on --analyze-in-stages option. If I understand well, motivation for this option is a get some minimal statistic for databases in minimal time. But when I tested, I found so iterations are per databases, not per stages - some first database get a maximum statistics and second has zero statistics. Isn't it unpractical?

Now:

DB a
  stage 1, stage2, stage3
DB b
  stage 1, stage2, stage3

should be:

Stage1
  DB a, DB b ...
Stage 2
  DB a, DB b ...
Stage 3
  DB a, DB b, ..

Regards

Pavel

pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: btree_gist macaddr valgrind woes
Next
From: Christoph Berg
Date:
Subject: Re: 9.4 beta1 crash on Debian sid/i386