On Fri, Jul 20, 2012 at 7:57 AM, Amit Kapila <[email protected]> wrote: >> From: [email protected] > [mailto:[email protected]] 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 ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
