Re: pgbench -i order of vacuum - Mailing list pgsql-hackers

From Tom Lane
Subject Re: pgbench -i order of vacuum
Date
Msg-id 24263.1342801604@sss.pgh.pa.us
Whole thread Raw
In response to Re: pgbench -i order of vacuum  (Jeff Janes <jeff.janes@gmail.com>)
Responses Re: pgbench -i order of vacuum  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Jeff Janes <jeff.janes@gmail.com> writes:
> On Fri, Jul 20, 2012 at 7:57 AM, Amit Kapila <amit.kapila@huawei.com> wrote:
>> 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?

Only for expression indexes, which there aren't any of in the standard
pgbench scenario.  I don't see a reason not to change the ordering
as you suggest.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Using pg_upgrade on log-shipping standby servers
Next
From: Aidan Van Dyk
Date:
Subject: Re: Using pg_upgrade on log-shipping standby servers