On Fri, Jul 20, 2012 at 7:57 AM, Amit Kapila <amit(dot)kapila(at)huawei(dot)com> wrote:
>> From: pgsql-hackers-owner(at)postgresql(dot)org
> [mailto:pgsql-hackers-owner(at)postgresql(dot)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
In response to
pgsql-hackers by date
|Next:||From: Robert Haas||Date: 2012-07-20 15:50:25|
|Subject: Re: Event Triggers reduced, v1|
|Previous:||From: Amit Kapila||Date: 2012-07-20 14:57:21|
|Subject: Re: pgbench -i order of vacuum|