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
>