Re: TOAST - why separate visibility map

Virender Singla <virender.cse@gmail.com>

From: Virender Singla <virender.cse@gmail.com>
To: PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2021-11-19T19:48:58Z
Lists: pgsql-hackers
Another point that currently manual VACUUM job does cleanup/freeze on
primary table first and then toast table. It looks easy pick to possibly
have a configurable parameter to run it on both the tables in parallel.

On Sat, Nov 20, 2021 at 12:15 AM Virender Singla <virender.cse@gmail.com>
wrote:

> Why do Toast tables have it's own visibility map and xmin, xmax columns
> etc?
> Isn't it increasing row size in a toast table and adding more complexity?
>
> Ideally all the vacuum cleanup on a TOAST can be done based on Primary
> table xmin,xmax and VM info. Yes, that makes any cleanup on TOAST to be
> glued up with the Primary table.
>
>
>