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 055BED1B377 for ; Mon, 19 Jul 2004 16:28:37 -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 46042-04 for ; Mon, 19 Jul 2004 19:28:35 +0000 (GMT) Received: from web51402.mail.yahoo.com (web51402.mail.yahoo.com [206.190.38.181]) by svr1.postgresql.org (Postfix) with SMTP id E87EBD1B366 for ; Mon, 19 Jul 2004 16:28:32 -0300 (ADT) Message-ID: <20040719192501.55745.qmail@web51402.mail.yahoo.com> Received: from [192.88.67.254] by web51402.mail.yahoo.com via HTTP; Mon, 19 Jul 2004 12:25:01 PDT Date: Mon, 19 Jul 2004 12:25:01 -0700 (PDT) From: Bill Chandler Subject: VACUUM ANALYZE and REINDEX To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.9 tagged_above=0.0 required=5.0 tests=FROM_ENDS_IN_NUMS X-Spam-Level: X-Archive-Number: 200407/217 X-Sequence-Number: 14285 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)? thanks, Bill __________________________________ Do you Yahoo!? Vote for the stars of Yahoo!'s next ad campaign! http://advision.webevents.yahoo.com/yahoo/votelifeengine/