Re: Inconsistent DB data in Streaming Replication

Поиск
Список
Период
Сортировка
От Pavan Deolasee
Тема Re: Inconsistent DB data in Streaming Replication
Дата
Msg-id CABOikdPL=TTsDtm1+a49+C=2XR3=W9pfAm-pWwdxq3EmeWdHMQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Inconsistent DB data in Streaming Replication  (Andres Freund <andres@2ndquadrant.com>)
Ответы Re: Inconsistent DB data in Streaming Replication
Список pgsql-hackers



On Fri, Apr 12, 2013 at 4:29 PM, Andres Freund <andres@2ndquadrant.com> wrote:


I don't think that holds true at all. If you look at pg_stat_bgwriter in
any remotely bugs cluster with a hot data set over shared_buffers you'll
notice that a large percentage of writes will have been done by backends
themselves.

Even if what you are saying it true, which I am sure is, the pages that the backend is evicting mustn't be recently used by the LRU algorithm which means that the WAL pertaining to the last change to the page in most likelihood is already replicated, unless the replication is really lagging much behind. Of course, if the standby is not able to keep pace with the master in a realistic manner then we have a problem with the approach.

Thanks,
Pavan

--
Pavan Deolasee
http://www.linkedin.com/in/pavandeolasee

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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: Inconsistent DB data in Streaming Replication
Следующее
От: Andres Freund
Дата:
Сообщение: Re: Inconsistent DB data in Streaming Replication