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