vacuums and ctid
От | Gaetano Mendola |
---|---|
Тема | vacuums and ctid |
Дата | |
Msg-id | cft22c$i1p$1@floppy.pyrenet.fr обсуждение исходный текст |
Ответы |
Re: vacuums and ctid
|
Список | pgsql-hackers |
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 not for a vacuum full. for a vacuum full I was expecting: 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; ( line B moved in ctid ( 0, 2) ) insert a line (C) in the table; ==> ctid = (0, 3); could this due the fact that moving that tuple will not save any storage space ? If not, am I missing something ? Regards Gaetano Mendola
В списке pgsql-hackers по дате отправления: