Re: Long running query causing XID limit breach

Поиск
Список
Период
Сортировка
От sud
Тема Re: Long running query causing XID limit breach
Дата
Msg-id CAD=mzVVqR-mKUFHetsejFWSPQPbLjTVhCmBebJTFX5XmYp+nGg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Long running query causing XID limit breach  (Laurenz Albe <laurenz.albe@cybertec.at>)
Ответы Re: Long running query causing XID limit breach
Список pgsql-general
Дерево обсуждения

On Thu, May 23, 2024 at 1:45 PM Laurenz Albe <laurenz.albe@cybertec.at> wrote:


If a long running query on the standby influences the primary, that means that
you have "hot_standby_feedback" set to "on".  Set it to "off".


Will the setting up of "hot_standby_feedback" value to OFF will cause the reader instance to give incorrect query results or unexpected query failure which will be potential inconsistency between the writer and reader instance, as because those XID's can be removed/cleaned by the writer node even if its being read by the reader instance query. And it can have more replication lag. So I'm wondering , if this setup is advisable one?

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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: Backup failure Postgres
Следующее
От: HORDER Philip
Дата:
Сообщение: Re: Restore of a reference database kills the auto analyze processing.