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 по дате отправления: