Re: [ADMIN] WAL configuration and REINDEX

[adey]

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 <[EMAIL PROTECTED]> wrote:

adey <[EMAIL PROTECTED]> 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