Postgres Pro
Downloads
Home   >   mailing lists

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

From adey
Subject Re: WAL configuration and REINDEX
Date
Msg-id 1c66bda80609242019k4969aa97taf56e2ae30d3bf29@mail.gmail.com
Whole thread Raw
In response to Re: WAL configuration and REINDEX  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: WAL configuration and REINDEX  (adey <adey11@gmail.com>)
List pgsql-admin
Tree view
Thanks Tom.
How does Postgres handle page splits and redirections in indexes then please?
I had an unsuccessful look at :-
 
and
 
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

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: WAL configuration and REINDEX
Next
From: Jim Nasby
Date:
Subject: Re: best OS and HW for postgreSQL