Re: Keepalive for max_standby_delay

Поиск
Список
Период
Сортировка
От Greg Stark
Тема Re: Keepalive for max_standby_delay
Дата
Msg-id AANLkTinziZwRWdTdAnc7XiaOr0DYuY56GX47shmST5s_@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Keepalive for max_standby_delay  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On Thu, Jun 3, 2010 at 4:34 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> The data keeps coming in and getting dumped into the slave's pg_xlog.
> walsender/walreceiver are not at all tied to the slave's application
> of WAL.  In principle we could have the code around max_standby_delay
> notice just how far behind it's gotten and adjust the delay tolerance
> based on that; but I think designing a feedback loop for that is 9.1
> material.

Er, no. In that case my first concern was misguided. I'm happy there's
no feedback loop -- my fear was that there was and it would mean the
"time received" could be decoupled from the time the wal was
generated. But as you describe it then the time received might be
slightly delayed from the time the wal was generated but to some
constant degree -- not in a way that will be influenced by the log
application being blocked on the slave.

--
greg


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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: functional call named notation clashes with SQL feature
Следующее
От: Robert Haas
Дата:
Сообщение: Re: functional call named notation clashes with SQL feature