Re: No xmin in pg_database

Поиск
Список
Период
Сортировка
От Laurenz Albe
Тема Re: No xmin in pg_database
Дата
Msg-id ceb3ee0058fc8d0cf5bf243e46a65eacd0ff56ce.camel@cybertec.at
обсуждение исходный текст
Ответ на No xmin in pg_database  (Alexander Kass <alexander.kass@jetbrains.com>)
Список pgsql-general
On Thu, 2021-09-02 at 12:10 +0300, Alexander Kass wrote:
> As for xmin usage, we have a working scheme. We fetch objects based on
> dbage(xid), starting from the oldest uncommitted transaction of
> previous synchronization.
> Do you think it does not work?

I don't know what exactly you are doing, so I cannot be certain.

age(xmin) will not necessarily tell you how many transactions
ago the row was created...

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com




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

Предыдущее
От: balasubramanian c r
Дата:
Сообщение: Querying a table with jaccard similarity with 1.6 million records take 12 seconds
Следующее
От: Matthew Tice
Дата:
Сообщение: Re: datfrozenxid not dropping after vacuum