Re: Hot Standby on git

Поиск
Список
Период
Сортировка
От Simon Riggs
Тема Re: Hot Standby on git
Дата
Msg-id 1254920737.26302.227.camel@ebony.2ndQuadrant
обсуждение исходный текст
Ответ на Re: Hot Standby on git  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Список pgsql-hackers
On Fri, 2009-10-02 at 10:32 +0300, Heikki Linnakangas wrote:
> Simon Riggs wrote:
> > I will docuemnt the recommendation to set max_standby_delay = 0 if
> > performing an archive recovery (and explain why).
> 
> Hmm, not sure if that's such a good piece of advice either. It will mean
> waiting for queries forever, which probably isn't what you want if
> you're performing archive recovery. Or maybe it is? Maybe -1? I guess it
> depends on the situation...

I've changed that to -1 now, which was what I meant. 0 is likely to be a
very wrong setting during archive recovery.

-- Simon Riggs           www.2ndQuadrant.com



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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: COPY enhancements
Следующее
От: Emmanuel Cecchet
Дата:
Сообщение: Re: COPY enhancements