Re: REINDEX checking of index constraints

On 07/21/2013 11:30 AM, Josh Berkus wrote:
> Noah,
>
>> Attached patch just restores the old behavior. Would it be worth preserving
>> the ability to fix an index consistency problem with a REINDEX independent
>> from related heap consistency problems such as duplicate keys?
>
> I would love to have two versions of REINDEX, one which validated and
> one which didn't. Maybe a ( validate off ) type check?

Cancel this. I just did some tests, and there amount of time required
for the validation (at least, in simple two-column table test) is < 10%
of the time required to reindex in general. At that difference, we
don't need two options.

Unless you're asking if we want a command to check the index validity
without rebuilding it? That might be more valuable ...

--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com