Re: Pg analog to DBCC CCHECKDB?

Поиск
Список
Период
Сортировка
От Michel Pelletier
Тема Re: Pg analog to DBCC CCHECKDB?
Дата
Msg-id CACxu=v+Tu7tce7YYsXe1jD0khxZ8oNCLZmmKZHnKjn9zUET6BQ@mail.gmail.com
обсуждение исходный текст
Ответ на Pg analog to DBCC CCHECKDB?  (Ron <ronljohnsonjr@gmail.com>)
Список pgsql-general
There is amcheck:


"When the heapallindexed argument to verification functions is true, an additional phase of verification is performed against the table associated with the target index relation. This consists of a “dummy” CREATE INDEX operation, which checks for the presence of all hypothetical new index tuples against a temporary, in-memory summarizing structure (this is built when needed during the basic first phase of verification). The summarizing structure “fingerprints” every tuple found within the target index. The high level principle behind heapallindexed verification is that a new index that is equivalent to the existing, target index must only have entries that can be found in the existing structure."

I haven't used this tool but it looks promising:



On Fri, Apr 5, 2019 at 7:34 AM Ron <ronljohnsonjr@gmail.com> wrote:
Hi,

In 9.6, does such a thing exist?  (We just restored a VM from snapshot and I
want to verify the cluster sanity.)

Thanks

--
Angular momentum makes the world go 'round.


В списке pgsql-general по дате отправления:

Предыдущее
От: Ron
Дата:
Сообщение: Pg analog to DBCC CCHECKDB?
Следующее
От: Peter Geoghegan
Дата:
Сообщение: Re: Pg analog to DBCC CCHECKDB?