Skip site navigation (1) Skip section navigation (2)

Re: pgbench -i order of vacuum

From: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
To: Amit Kapila <amit(dot)kapila(at)huawei(dot)com>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: pgbench -i order of vacuum
Date: 2012-07-20 15:37:08
Message-ID: CAMkU=1xqhCpBeBXjO3oEnh4q4emDSZVc6hrLyzMcHQ6Y15-6Fw@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackers
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
all-visible-dead entries.

Cheers,

Jeff

In response to

Responses

pgsql-hackers by date

Next:From: Robert HaasDate: 2012-07-20 15:50:25
Subject: Re: Event Triggers reduced, v1
Previous:From: Amit KapilaDate: 2012-07-20 14:57:21
Subject: Re: pgbench -i order of vacuum

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group