"Pavan Deolasee" <pavan(dot)deolasee(at)gmail(dot)com> writes:
> I know it might break the ctid chain, but does that really matter ?
Yes. You can't just decide that the tuple isn't needed anymore.
As per other followup, you could possibly shrink a known-dead tuple to
just the header.
The notion of keeping linked lists etc seems like gross overdesign to me.
Why not just compact out the free space?
regards, tom lane