Re: No xmin in pg_database

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: No xmin in pg_database
Дата
Msg-id 2241619.1630579303@sss.pgh.pa.us
обсуждение исходный текст
Ответ на No xmin in pg_database  (Alexander Kass <alexander.kass@jetbrains.com>)
Ответы Re: No xmin in pg_database  (Alexander Kass <alexander.kass@jetbrains.com>)
Список pgsql-general
Laurenz Albe <laurenz.albe@cybertec.at> writes:
> On Thu, 2021-09-02 at 08:50 +0300, Alexander Kass wrote:
>> We have a small number of users that do not have xmin in pg_database
>> (we've asked them to try `select xmin from pg_database` and got
>> `column xmin does not exist`).

> All PostgreSQL tables have "xmin", and all catalog tables do as well.

Indeed.  This seems to be evidence of corruption in the pg_attribute
catalog.  If you're really lucky, reindexing pg_attribute might fix
it, though I wonder what other problems there are.  (It's odd though
that identical corruption would happen to different installations.)

            regards, tom lane



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

Предыдущее
От: Alexander Kass
Дата:
Сообщение: Re: No xmin in pg_database
Следующее
От: balasubramanian c r
Дата:
Сообщение: Querying a table with jaccard similarity with 1.6 million records take 12 seconds