Re: Proper use of pg_xlog_location_diff()

On 1/15/15 8:41 PM, Fabio Ugo Venchiarutti wrote:
> Does it mean that pg_last_xlog_receive_location() returns the last WAL record that has been successfully "staged for
replay"by the stream replication whereas pg_last_xlog_replay_location() returns the last successful WAL replay
regardlessof it coming from streaming or archive shipping? 
> As in 2 different stages the first of which is basically irrelevant to record visibility?

(At least in -HEAD) receive is what's been committed to disk; replay is what's actually been replayed and should be
visible.
--
Jim Nasby, Data Architect, Blue Treble Consulting
Data in Trouble? Get it in Treble! http://BlueTreble.com