Re: WAL configuration and REINDEX - Mailing list pgsql-admin

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@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