"Zeugswetter Andreas DCP SD" <[EMAIL PROTECTED]> writes: > Why do we not truncate the line pointer array ? > Is it, that vacuum (not the "full" version) does not move > rows to other pages or slots ? Of course vacuum full could do it, > but I see your point.
We can't reassign tuple TIDs safely except in vacuum full. It's possible that a plain vacuum could safely truncate off unused line pointers at the end of the array, but in the absence of a forcing function to make those pointers become unused, I'm not sure it'd help much. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend