Re: WAL configuration and REINDEX

[adey <adey11@xxxxxxxxx>]

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@xxxxxxxxx> 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@xxxxxxxxxxxxx> wrote:

adey < adey11@xxxxxxxxx> 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