> From: pgsql-hackers-owner@postgresql.org
[mailto:pgsql-hackers-owner@postgresql.org] On Behalf Of Jeff Janes
> Sent: Friday, July 20, 2012 5:36 AM
> Is there a reason to vacuum the pgbench_* tables after the indexes on them
are built, rather than before?
> Since the indexes are on fresh tables, they can't have anything that needs
to be cleaned.
The command it executes is "vacuum analyze ..", so it will do analyze also
on table which means
it will collect stats corresponding to table and index. So if you do it
before creation of index pgbench might behave
different.
In specific, from function do_analyze_rel(), it will not call
compute_index_stats() if you execute the command before
Creation of index.
With Regards,
Amit Kapila.