Re: WAL configuration and REINDEX

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

On 9/25/06, adey <adey11(at)gmail(dot)com> wrote:
>
> 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 <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> >
> > adey <adey11(at)gmail(dot)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
> >
>
>