Re: partial heap only tuples - Mailing list pgsql-hackers

From Andres Freund
Subject Re: partial heap only tuples
Date
Msg-id 20210213162623.4upmsuzwv2anqoqx@alap3.anarazel.de
Whole thread Raw
In response to partial heap only tuples  ("Bossart, Nathan" <bossartn@amazon.com>)
Responses Re: partial heap only tuples
List pgsql-hackers
Hi,

On 2021-02-09 18:48:21 +0000, Bossart, Nathan wrote:
> In order to be eligible for cleanup, the final tuple in the
> corresponding PHOT/HOT chain must also be eligible for cleanup, or all
> indexes must have been updated later in the chain before any visible
> tuples.

This sounds like it might be prohibitively painful. Adding effectively
unremovable bloat to remove other bloat is not an uncomplicated
premise. I think you'd really need a way to fully remove this as part of
vacuum for this to be viable.

Greetings,

Andres Freund



pgsql-hackers by date:

Previous
From: "Joel Jacobson"
Date:
Subject: Re: [HACKERS] GSoC 2017: Foreign Key Arrays
Next
From: Andres Freund
Date:
Subject: Re: repeated decoding of prepared transactions