Re: Inconsistent DB data in Streaming Replication - Mailing list pgsql-hackers

From Pavan Deolasee
Subject Re: Inconsistent DB data in Streaming Replication
Date
Msg-id CABOikdPL=TTsDtm1+a49+C=2XR3=W9pfAm-pWwdxq3EmeWdHMQ@mail.gmail.com
Whole thread Raw
In response to Re: Inconsistent DB data in Streaming Replication  (Andres Freund <andres@2ndquadrant.com>)
Responses Re: Inconsistent DB data in Streaming Replication
List 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 by date:

Previous
From: Andres Freund
Date:
Subject: Re: Inconsistent DB data in Streaming Replication
Next
From: Andres Freund
Date:
Subject: Re: Inconsistent DB data in Streaming Replication