Re: pgbench -i order of vacuum
Robert Haas <robertmhaas@gmail.com>
From: Robert Haas <robertmhaas@gmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Jeff Janes <jeff.janes@gmail.com>, Amit Kapila <amit.kapila@huawei.com>, pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2012-07-23T18:45:01Z
Lists: 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