Postgres Pro
Downloads
Home   >   mailing lists

Re: when to reindex? - Mailing list pgsql-general

From Jeremy Harris
Subject Re: when to reindex?
Date
Msg-id 484A9D18.2080103@wizmail.org
Whole thread Raw
In response to Re: when to reindex?  (Gregory Stark <stark@enterprisedb.com>)
Responses Re: when to reindex?  ("Gurjeet Singh" <singh.gurjeet@gmail.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Viktor Rosenfeld
Date:
Subject: temporarily deactivate an index
Next
From: "Scott Marlowe"
Date:
Subject: Re: temporarily deactivate an index