Gaetano Mendola <[EMAIL PROTECTED]> writes:
> could this due the fact that moving that tuple will not
> save any storage space ?
Yup. VACUUM FULL is not interested in collapsing out unused CTID slots.
regards, tom lane
---(end of broadcast)---
Hi all,
looking at how ctid is used is clear to me:
insert line (A) in a table; ==> ctid = (0, 1);
rollback an update for the line (A);
insert a line (B) in the table; ==> ctid = (0, 3);
vacuum full;
insert a line (C) in the table; ==> ctid = (0, 2);
I was expecting this for a normal vacuum
