Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 48ECA1337B6B for ; Tue, 21 Sep 2010 17:44:28 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 75310-06 for ; Tue, 21 Sep 2010 20:44:22 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by mail.postgresql.org (Postfix) with ESMTP id 1173B1337B47 for ; Tue, 21 Sep 2010 17:44:20 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id o8LKiKHg008964; Tue, 21 Sep 2010 16:44:20 -0400 (EDT) To: Joe Miller cc: pgsql-performance@postgresql.org Subject: Re: Auto ANALYZE criteria In-reply-to: References: <21216.1285035151@sss.pgh.pa.us> Comments: In-reply-to Joe Miller message dated "Tue, 21 Sep 2010 09:33:00 -0400" Date: Tue, 21 Sep 2010 16:44:20 -0400 Message-ID: <8963.1285101860@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-10 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201009/136 X-Sequence-Number: 40339 Joe Miller writes: > I was looking at the autovacuum documentation: > http://www.postgresql.org/docs/9.0/interactive/routine-vacuuming.html#AUTOVACUUM > For analyze, a similar condition is used: the threshold, defined as: > analyze threshold = analyze base threshold + analyze scale factor * > number of tuples > is compared to the total number of tuples inserted or updated since > the last ANALYZE. > I guess that should be updated to read "insert, updated or deleted". Mph. We caught the other places where the docs explain what the analyze threshold is, but missed that one. Fixed, thanks for pointing it out. regards, tom lane