Re: found xmin from before relfrozenxid on pg_catalog.pg_authid

Поиск
Список
Период
Сортировка
От Peter Geoghegan
Тема Re: found xmin from before relfrozenxid on pg_catalog.pg_authid
Дата
Msg-id CAH2-WznjoRqEHcBvDeSyV=wmtw6rx3zAyg60ggj02Rg31FJF-g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: found xmin from before relfrozenxid on pg_catalog.pg_authid  (Jeremy Finzel <finzelj@gmail.com>)
Ответы Re: found xmin from before relfrozenxid on pg_catalog.pg_authid
Список pgsql-general
On Thu, Mar 22, 2018 at 12:27 PM, Jeremy Finzel <finzelj@gmail.com> wrote:
> Thank you for the recommendation.  I ran both amcheck functions on all 4
> indexes of those 2 tables with heapallindexed = true, but no issues were
> found.

Probably wouldn't hurt to run it against all indexes, if you can make
time for that. If you can generalize from the example query that calls
the bt_index_check() function, but set
"heapallindexed=>i.indisprimary" and remove "n.nspname =
'pg_catalog'", as well as "LIMIT 10".  This will test tables and
indexes from all schemas, which might be interesting.
-- 
Peter Geoghegan


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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: found xmin from before relfrozenxid on pg_catalog.pg_authid
Следующее
От: Jeremy Finzel
Дата:
Сообщение: Re: found xmin from before relfrozenxid on pg_catalog.pg_authid