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.



Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:

Reply via email to