Does max_standby_streaming_delay delay all WAL commits?

Поиск
Список
Период
Сортировка
От Dave Johansen
Тема Does max_standby_streaming_delay delay all WAL commits?
Дата
Msg-id CAAcYxUeCD0jP8yR7SGmQWDAA2a29KJz_eCX1FvgR3bHZY6ONvA@mail.gmail.com
обсуждение исходный текст
Ответы Re: Does max_standby_streaming_delay delay all WAL commits?
Список pgsql-admin
We're running into issues with canceled queries on a standby server and have be debating between enabling hot_standby_feedback and setting max_standby_streaming_delay to something large.

Using max_standby_streaming_delay seems to have the advantage of keeping the master independent of the standby, but will a long running query mean that all WAL commits are delayed? Or just those that affected by the long running query?

Thanks,
Dave

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

Предыдущее
От: bricklen
Дата:
Сообщение: Re: pg_dump limit 1000 rows
Следующее
От: "Don O'Hara"
Дата:
Сообщение: Changing schema name when restoring?