Re: Streaming replication, and walsender during recovery

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Streaming replication, and walsender during recovery
Дата
Msg-id 18300.1264701940@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Streaming replication, and walsender during recovery  (Simon Riggs <simon@2ndQuadrant.com>)
Ответы Re: Streaming replication, and walsender during recovery  (Simon Riggs <simon@2ndQuadrant.com>)
Re: Streaming replication, and walsender during recovery  (Greg Smith <greg@2ndquadrant.com>)
Re: Streaming replication, and walsender during recovery  ("Joshua D. Drake" <jd@commandprompt.com>)
Re: Streaming replication, and walsender during recovery  ("Joshua D. Drake" <jd@commandprompt.com>)
Список pgsql-hackers
Simon Riggs <simon@2ndQuadrant.com> writes:
> On Thu, 2010-01-28 at 11:41 -0500, Tom Lane wrote:
>> FWIW, I don't agree with that prioritization in the least.  Cascading
>> is something we could leave till 9.1, or even later, and 

> Not what you said just a few days ago.

Me?  I don't recall having said a word about cascading before.

> I'm a little worried the feature set of streaming rep isn't any better
> than what we have already.

Nonsense.  Getting rid of the WAL-segment-based shipping delays is a
quantum improvement --- it means we actually have something approaching
real-time replication, which was really impractical before.  Whether you
can feed slaves indirectly is just a minor administration detail.  Yeah,
I know in some situations it could be helpful for performance, but
it's not even in the same ballpark of must-have-ness.

(Anyway, the argument that it's important for performance is pure
speculation AFAIK, untainted by any actual measurements.  Given the lack
of optimization of WAL replay, it seems entirely possible that the last
thing you want to burden a slave with is sourcing data to more slaves.)
        regards, tom lane


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: plperl compiler warning
Следующее
От: Robert Haas
Дата:
Сообщение: Re: quoting psql varible as identifier