A Deeper Look Inside PostgreSQL Visibility Check Mechanism
What is Visibility? Simply put, the visibility refers to whether a row of data (Heap Tuple by default) should be displayed to the user in certain states, backend processes, or transactions. For example, MVCC (Multi-Version Concurrency Control) is a method in which each write operation creates a “new version” of the data while retaining the…
Read more
Recent Comments