Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 6066B9F9F80 for ; Sun, 24 Sep 2006 20:32:51 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 90539-03-2 for ; Sun, 24 Sep 2006 20:32:48 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 68E739FB2A9 for ; Sun, 24 Sep 2006 20:32:48 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id k8ONWOKg013161; Sun, 24 Sep 2006 19:32:24 -0400 (EDT) To: adey cc: "Jim Nasby" , garcia_josval@gva.es, pgsql-admin@postgresql.org, "Jose Alarcon" Subject: Re: WAL configuration and REINDEX In-reply-to: <1c66bda80609241523p2c111042p96bb2f935da08f51@mail.gmail.com> References: <45126C37.6020106@gva.es> <8CC6FC7A-C737-4473-99E1-9860FA61D9C5@enterprisedb.com> <1c66bda80609241523p2c111042p96bb2f935da08f51@mail.gmail.com> Comments: In-reply-to adey message dated "Mon, 25 Sep 2006 10:23:09 +1200" Date: Sun, 24 Sep 2006 19:32:23 -0400 Message-ID: <13160.1159140743@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.098 tagged_above=0 required=5 tests=AWL, SPF_HELO_PASS, SPF_PASS X-Spam-Level: X-Archive-Number: 200609/257 X-Sequence-Number: 23171 adey writes: > I apologise if I am uninformed, but it is my understanding that REINDEX is > still required even with the most regular of vacuums? REINDEX shouldn't be required at all under normal circumstances. regards, tom lane