X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 7056BD1B391 for ; Mon, 19 Jul 2004 17:05:52 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 63464-08 for ; Mon, 19 Jul 2004 20:05:52 +0000 (GMT) Received: from mpls-qmqp-04.inet.qwest.net (mpls-qmqp-04.inet.qwest.net [63.231.195.115]) by svr1.postgresql.org (Postfix) with SMTP id 69A1DD1B388 for ; Mon, 19 Jul 2004 17:05:46 -0300 (ADT) Received: (qmail 35994 invoked by uid 0); 19 Jul 2004 20:05:43 -0000 Received: from mpls-pop-12.inet.qwest.net (63.231.195.12) by mpls-qmqp-04.inet.qwest.net with QMQP; 19 Jul 2004 20:05:43 -0000 Received: from 63-227-127-37.dnvr.qwest.net (HELO ?10.0.0.2?) (63.227.127.37) by mpls-pop-12.inet.qwest.net with SMTP; 19 Jul 2004 20:05:42 -0000 Date: Mon, 19 Jul 2004 14:06:53 -0600 Message-Id: <1090267613.709.3.camel@localhost.localdomain> From: "Scott Marlowe" To: "Bill Chandler" Cc: pgsql-admin@postgresql.org Subject: Re: VACUUM ANALYZE and REINDEX In-Reply-To: <20040719192501.55745.qmail@web51402.mail.yahoo.com> References: <20040719192501.55745.qmail@web51402.mail.yahoo.com> Content-Type: text/plain Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.1 tagged_above=0.0 required=5.0 tests=RCVD_IN_SORBS X-Spam-Level: X-Archive-Number: 200407/220 X-Sequence-Number: 14288 On Mon, 2004-07-19 at 13:25, Bill Chandler wrote: > Hello, > > I'm sorry if this too basic. I searched the web but > could not find an answer. > > Q1: When you do a VACUUM ANALYZE does it update the > statistics for existing indexes on the table? Or do > you have to do an explicit REINDEX command on the > index (or possibly drop and recreate the index)? analyze has no effect on indexes, it is performed on the tables directly. The stats are then used to decide when to use / not use an index. Reindexing is used to fix broken or bloated indexes, and is not related to analyze.