Ever wondered on how PostgreSQL maintains old and new data image in same table and still show only new data when queried? It is through Tuple Visibility rules. If you are aware of t_xmin, t_xmax of a tuple , clog and transaction snapshot, jump to 21.26 seconds to view visibility rules directly.
