On Fri, Jul 20, 2012 at 7:57 AM, Amit Kapila <amit.kap...@huawei.com> wrote: >> 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.
Are there stats collected on indexes? I thought all stats were on tables only, and the only reason to visit the index was to remove all-visible-dead entries. Cheers, Jeff -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
