Re: Question on Hot Standby in PostgreSQL

On Nov 20, 2015, at 12:50 PM, Williams, Alex <awilliams@teamdrg.com> wrote:
>
> However, I thought with the use of MVCC,
> an active query on the slave (long running, 30 seconds+) can run reading
> from row xid versions/snapshot...

The problem is that the master could well make changes that would remove rows in that snapshot because the master does
notknow anything about the rows that need preserving for the replica's query. 

That said, IIRC there may be something in 9.4 or 9.5 which provides for the replica to send that info to the server in
orderto coordinate things, but I haven't used that and so cannot offer more. 

--
Scott Ribe
scott_ribe@elevated-dev.com
http://www.elevated-dev.com/
https://www.linkedin.com/in/scottribe/
(303) 722-0567 voice