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

From Robert Haas
Subject Re: pgbench -i order of vacuum
Date
Msg-id CA+TgmoY9vva2xiRtC4ovpjQ8DNiyCaZOGd9rtH-dGHG6n5vrhw@mail.gmail.com
Whole thread Raw
In response to Re: pgbench -i order of vacuum  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Fri, Jul 20, 2012 at 12:26 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> 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.

OK, done.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [BUGS] BUG #6748: sequence value may be conflict in some cases
Next
From: Andrew Dunstan
Date:
Subject: Re: postgres 9 bind address for replication