Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id C4F759FA4D7 for ; Mon, 25 Sep 2006 00:19:26 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 38056-01 for ; Mon, 25 Sep 2006 03:19:18 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from wx-out-0506.google.com (wx-out-0506.google.com [66.249.82.225]) by postgresql.org (Postfix) with ESMTP id 2A01E9FA6B3 for ; Mon, 25 Sep 2006 00:19:18 -0300 (ADT) Received: by wx-out-0506.google.com with SMTP id t13so1765896wxc for ; Sun, 24 Sep 2006 20:19:17 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=Fh36lpTSdLaphhxd+hYfFJ8O/MjExduwn0LPyNF0iJANQSZ6MYQFEFD10gr3jk8LSoFrrPJdHy38g4B22fikEUkz0+KcVLJFxqY/hiq2V/K636D/ER4sjMq9p3c+cOuWFraeOPwovpXfe1ubUo4DSmMfzFVPb3H4U8kewQnp9Lc= Received: by 10.90.68.15 with SMTP id q15mr1134426aga; Sun, 24 Sep 2006 20:19:17 -0700 (PDT) Received: by 10.90.93.9 with HTTP; Sun, 24 Sep 2006 20:19:17 -0700 (PDT) Message-ID: <1c66bda80609242019k4969aa97taf56e2ae30d3bf29@mail.gmail.com> Date: Mon, 25 Sep 2006 15:19:17 +1200 From: adey To: "Tom Lane" Subject: Re: WAL configuration and REINDEX Cc: pgsql-admin@postgresql.org In-Reply-To: <13160.1159140743@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_17882_2735735.1159154357190" References: <45126C37.6020106@gva.es> <8CC6FC7A-C737-4473-99E1-9860FA61D9C5@enterprisedb.com> <1c66bda80609241523p2c111042p96bb2f935da08f51@mail.gmail.com> <13160.1159140743@sss.pgh.pa.us> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.134 tagged_above=0 required=5 tests=HTML_50_60, HTML_MESSAGE, SPF_PASS X-Spam-Level: X-Archive-Number: 200609/258 X-Sequence-Number: 23172 ------=_Part_17882_2735735.1159154357190 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline Thanks Tom. How does Postgres handle page splits and redirections in indexes then please? I had an unsuccessful look at :- http://www.postgresql.org/docs/8.1/interactive/index-functions.html and http://www.postgresql.org/docs/8.1/interactive/indexes-types.html On 9/25/06, Tom Lane wrote: > > 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 > ------=_Part_17882_2735735.1159154357190 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline
Thanks Tom.
How does Postgres handle page splits and redirections in indexes then please?
I had an unsuccessful look at :-
 
and
 
On 9/25/06, Tom Lane <tgl@sss.pgh.pa.us> wrote:
adey <adey11@gmail.com> 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

------=_Part_17882_2735735.1159154357190--