> From: pgsql-hackers-ow...@postgresql.org [mailto:pgsql-hackers-ow...@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. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers