Re: REINDEX checking of index constraints

From: "ktm(at)rice(dot)edu" <ktm(at)rice(dot)edu>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: REINDEX checking of index constraints
Date: 2013-07-22 12:51:45
Message-ID: 20130722125145.GH3001@aart.rice.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2013-07-22 12:53:53 Re: enum-ify resource manager's xl_info values
Previous Message Peter Eisentraut 2013-07-22 11:50:32 Re: improve Chinese locale performance