Re: Importance of re-index - Mailing list pgsql-general

From Tom Lane
Subject Re: Importance of re-index
Date
Msg-id 27345.1154646192@sss.pgh.pa.us
Whole thread Raw
In response to Re: Importance of re-index  (Scott Marlowe <smarlowe@g2switchworks.com>)
Responses Re: Importance of re-index  (Scott Marlowe <smarlowe@g2switchworks.com>)
List pgsql-general
Scott Marlowe <smarlowe@g2switchworks.com> writes:
> Reindex was originally
> designed to fix broken indexes, and, at least in earlier encarnations,
> should something stop it in the middle of reindexing I believe it is
> possible to be left with no index.

That was once true but these days reindex is perfectly crash-safe.  The
only case where it's not is where you want to reindex a shared catalog's
index (eg one of pg_database's), and we don't let you do that in
multiuser mode anyway.

            regards, tom lane

pgsql-general by date:

Previous
From: Ron Johnson
Date:
Subject: Re: Importance of re-index
Next
From: John Sidney-Woollett
Date:
Subject: Re: Best Procedural Language?