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

From Zeugswetter Andreas DAZ SD
Subject Re: Pre-allocated free space for row
Date
Msg-id E1539E0ED7043848906A8FF995BDA57966FB84@m0143.s-mxs.net
Whole thread Raw
List pgsql-hackers
> > 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).

Ok, you could leave all toast pointers and the toast table as is.

Andreas


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Remove xmin and cmin from frozen tuples
Next
From: Andrew - Supernews
Date:
Subject: Re: TODO item: set proper permissions on non-system schemas