Re: when to reindex?

From: Jeremy Harris <jgh(at)wizmail(dot)org>
To: Postgres General List <pgsql-general(at)postgresql(dot)org>
Subject: Re: when to reindex?
Date: 2008-06-07 14:37:12
Message-ID: 484A9D18.2080103@wizmail.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Gregory Stark wrote:
> REINDEX scans the table
> precisely once and sorts it.

For the bloat, as opposed to corruption, case -
what information is needed from the table that
is not in the old index? Why would a sequential
read of the old index alone (then some processing)
not suffice?

Thanks,
Jeremy Harris

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2008-06-07 14:53:01 Re: temporarily deactivate an index
Previous Message Viktor Rosenfeld 2008-06-07 14:05:47 temporarily deactivate an index