Re: [ADMIN] WAL configuration and REINDEX

[adey]

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