Re: Pre-allocated free space for row - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Pre-allocated free space for row
Date
Msg-id 11756.1125578532@sss.pgh.pa.us
Whole thread Raw
In response to Re: Pre-allocated free space for row  ("Zeugswetter Andreas DAZ SD" <ZeugswetterA@spardat.at>)
List pgsql-hackers
"Zeugswetter Andreas DAZ SD" <ZeugswetterA@spardat.at> writes:
> The bgwriter could "update" all columns of dead heap tuples in heap
> pages
> to NULL and thus also gain free space without the need to touch the
> indexes.
> The slot would stay used but it would need less space.

Not unless it's running a transaction (consider TOAST updates).
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Zeugswetter Andreas DAZ SD"
Date:
Subject: Re: Pre-allocated free space for row
Next
From: Tom Lane
Date:
Subject: Re: On hardcoded type aliases and typmod for user types