From: Tom Lane <tgl@sss.pgh.pa.us>
To: tim_wilson <tim.wilson@telogis.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Re: autovacuum vacuum creates bad statistics for planner when it log index scans: 0
Date: Thu, 05 Jun 2014 22:02:01 -0400
Message-ID: <32562.1402020121@sss.pgh.pa.us> (raw)
In-Reply-To: <1402016119875-5806283.post@n5.nabble.com>
References: <1400459729388-5804416.post@n5.nabble.com>
<11299.1400559202@sss.pgh.pa.us>
<1402016119875-5806283.post@n5.nabble.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
tim_wilson <tim.wilson@telogis.com> writes:
> Thanks for you response Tom:
> but what does index_scans:0 mean? vs index scans: 1?
I believe the former means that VACUUM found no removable tuples, so it
had no need to make any passes over the table's indexes.
(Ordinarily you wouldn't see the number of scans as more than 1, unless
VACUUM removed quite a lot of dead tuples, more than it could remember
within maintenance_work_mem; in which case it would make multiple passes
over the indexes to remove index entries.)
regards, tom lane
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: tgl@sss.pgh.pa.us, tim.wilson@telogis.com
Subject: Re: Re: autovacuum vacuum creates bad statistics for planner when it log index scans: 0
In-Reply-To: <32562.1402020121@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox