Postgres Pro
Downloads
Home   >   mailing lists

Re: REINDEX slow? - Mailing list pgsql-general

From Tom Lane
Subject Re: REINDEX slow?
Date
Msg-id 28843.1081740858@sss.pgh.pa.us
Whole thread Raw
In response to REINDEX slow?  (Edmund Dengler <edmundd@eSentire.com>)
Responses Re: REINDEX slow?
List pgsql-general
Tree view 
Edmund Dengler <edmundd@eSentire.com> writes:
> Question: Does a REINDEX use the old version to build
> the new version, or is it the semantic equivalent to "drop index;  build
> new index".

The latter.

> If the second, any particular reason

REINDEX is customarily used to recover from a corrupted-index situation.

            regards, tom lane

pgsql-general by date:

Previous
From: Clodoaldo Pinto Neto
Date:
Subject: Re: ERROR: REINDEX DATABASE: Can be executed only on the currently open database.
Next
From: "Siew Hui, Wong"
Date:
Subject: Re: Error in function to pg_dump: Standard in must be a tty