Takes long time to "fail back" using pg_rewind

Поиск
Список
Период
Сортировка
От Joakim Lundgren
Тема Takes long time to "fail back" using pg_rewind
Дата
Msg-id CABcZ8inJaWGHSC1xO3MV5v=OtmH2aemxjwZHujdODd-yun7_Lg@mail.gmail.com
обсуждение исходный текст
Ответы Re: Takes long time to "fail back" using pg_rewind  (Joakim Lundgren <lundgren700@gmail.com>)
Список pgsql-admin
Hi!

I experience that it takes a long time (several GB of data is fetched) to use pg_rewind to do a failback when the former master has failed over to the former standby (which is now master) and is started again and very little data (like one row updated) is updated. I have upgraded to the latest version (10.5), but still think it takes equally long time. I found this bugfix (https://www.postgresql.org/message-id/flat/0A3221C70F24FB45833433255569204D1F8D6C7A@G01JPEXMBYT05) from late February this year. So would like to check if somebody knows if this fix is incorporated in standard postgreSQL, or if anybody else experience the same issue.

Thanks for any answer!

/Regards Joakim Lundgren

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

Предыдущее
От: Anders Wegge Keller
Дата:
Сообщение: Detect when streaming replication stops streaming.
Следующее
От: Joakim Lundgren
Дата:
Сообщение: Re: Takes long time to "fail back" using pg_rewind