Re: "68.4. Visibility Map" change suggestion.

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: jameschancojr87(at)gmail(dot)com, pgsql-docs(at)lists(dot)postgresql(dot)org
Subject: Re: "68.4. Visibility Map" change suggestion.
Date: 2021-04-27 09:28:37
Message-ID: ba4bf492f1cf75934dc8eec3aab5cdcc4ed22bc2.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

On Mon, 2021-04-26 at 21:55 +0000, PG Doc comments form wrote:
> The following documentation comment has been logged on the website:
>
> Page: https://www.postgresql.org/docs/12/storage-vm.html
> Description:
>
> Currently the documentation lists the line below;
>
> `Each heap relation has a Visibility Map (VM) to keep track of which pages
> contain only tuples that are known to be visible to all active
> transactions;`
>
> Should it instead read like;
>
> `Each heap relation has a Visibility Map (VM) to keep track of only those
> pages that contain tuples known to be visible to all active transactions;`
>
> After reading through the documentation and reading the first line, I first
> thought that VM only kept track of pages that only had visible tuples.
> Instead my understanding is that it shows which pages have any visible
> tuples in them.

I think that the wording of the documentation is more correct.

The VM also tracks the pages that are not all-visible. They have the
corresponding bit set to 0.

Yours,
Laurenz Albe

In response to

Browse pgsql-docs by date

  From Date Subject
Next Message PG Doc comments form 2021-04-27 14:26:48 Clarify how triggers relate to transactions
Previous Message PG Doc comments form 2021-04-26 21:55:25 "68.4. Visibility Map" change suggestion.