Re: REINDEX checking of index constraints - Mailing list pgsql-hackers

From ktm@rice.edu
Subject Re: REINDEX checking of index constraints
Date
Msg-id 20130722125145.GH3001@aart.rice.edu
Whole thread Raw
In response to Re: REINDEX checking of index constraints  (Josh Berkus <josh@agliodbs.com>)
List pgsql-hackers
On Sun, Jul 21, 2013 at 11:30:54AM -0700, 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?
> 
+1 There are reasons to reindex that do not involve its validity and it would
be great to not need to visit the heap for that.

Regards,
Ken



pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: improve Chinese locale performance
Next
From: Tom Lane
Date:
Subject: Re: enum-ify resource manager's xl_info values