Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 15D719FB41F for ; Tue, 26 Sep 2006 12:02:28 -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 53272-06 for ; Tue, 26 Sep 2006 12:02:23 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from lists.commandprompt.com (host-130.commandprompt.net [207.173.203.130]) by postgresql.org (Postfix) with ESMTP id 3960C9FB41E for ; Tue, 26 Sep 2006 12:02:22 -0300 (ADT) Received: from alvh.no-ip.org (201-221-219-6.bk12-dsl.surnet.cl [201.221.219.6]) (authenticated bits=0) by lists.commandprompt.com (8.13.7/8.13.6) with ESMTP id k8QF2Ma0012796; Tue, 26 Sep 2006 08:02:22 -0700 Received: by alvh.no-ip.org (Postfix, from userid 1000) id B4BBAC2D408; Tue, 26 Sep 2006 11:02:19 -0400 (CLT) Date: Tue, 26 Sep 2006 11:02:19 -0400 From: Alvaro Herrera To: adey Cc: Tom Lane , pgsql-admin@postgresql.org Subject: Re: WAL configuration and REINDEX Message-ID: <20060926150219.GV6330@alvh.no-ip.org> Mail-Followup-To: adey , Tom Lane , pgsql-admin@postgresql.org References: <45126C37.6020106@gva.es> <8CC6FC7A-C737-4473-99E1-9860FA61D9C5@enterprisedb.com> <1c66bda80609241523p2c111042p96bb2f935da08f51@mail.gmail.com> <13160.1159140743@sss.pgh.pa.us> <1c66bda80609242019k4969aa97taf56e2ae30d3bf29@mail.gmail.com> <1c66bda80609251538g73899f2m8edd01290d1214f6@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <1c66bda80609251538g73899f2m8edd01290d1214f6@mail.gmail.com> User-Agent: Mutt/1.5.13 (2006-08-11) X-Virus-Scanned: ClamAV version 0.88.4, clamav-milter version 0.88.4 on projects.commandprompt.com X-Virus-Status: Clean X-Greylist: Sender succeded SMTP AUTH authentication, not delayed by milter-greylist-1.6 (lists.commandprompt.com [192.168.2.159]); Tue, 26 Sep 2006 08:02:23 -0700 (PDT) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.256 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200609/292 X-Sequence-Number: 23206 adey wrote: > Hi Tom, > Further to my request below, the following recommendation exists in the > Postgres 8.1 documentation:- > http://www.postgresql.org/docs/8.1/interactive/routine-reindex.html Did you actually read that page? It says that there are some circumstances under which reindex is still required, but they should be rare. It doesn't have anything to do with page splits though. The problem is with page merging not being implemented (contiguous partially-filled pages are not merged) -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc.