Re: HOT line pointer bloat and PageRepairFragmentation - Mailing list pgsql-hackers

From Tom Lane
Subject Re: HOT line pointer bloat and PageRepairFragmentation
Date
Msg-id 14680.1189694548@sss.pgh.pa.us
Whole thread Raw
In response to HOT line pointer bloat and PageRepairFragmentation  ("Pavan Deolasee" <pavan.deolasee@gmail.com>)
Responses Re: HOT line pointer bloat and PageRepairFragmentation
List pgsql-hackers
"Pavan Deolasee" <pavan.deolasee@gmail.com> writes:
> How about passing a boolean to PageRepairFragmentation to
> command it to reclaim unused line pointers ?

The difficulty with this is having to be 100% confident that noplace in
the system tries to dereference a TID without checking that the line
number (offset) is within range.  At one time that was demonstrably
not so.  I think we've cleaned up most if not all such places, but
I wouldn't want to swear to it.

I'm not convinced it's worth taking any risk for.
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Pavan Deolasee"
Date:
Subject: HOT line pointer bloat and PageRepairFragmentation
Next
From: "Pavan Deolasee"
Date:
Subject: Re: HOT line pointer bloat and PageRepairFragmentation