Re: REINDEX checking of index constraints

Поиск
Список
Период
Сортировка
От ktm@rice.edu
Тема Re: REINDEX checking of index constraints
Дата
Msg-id 20130722125145.GH3001@aart.rice.edu
обсуждение исходный текст
Ответ на Re: REINDEX checking of index constraints  (Josh Berkus <josh@agliodbs.com>)
Список 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 по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: improve Chinese locale performance
Следующее
От: Tom Lane
Дата:
Сообщение: Re: enum-ify resource manager's xl_info values