vacuums and ctid

Поиск
Список
Период
Сортировка
От Gaetano Mendola
Тема vacuums and ctid
Дата
Msg-id cft22c$i1p$1@floppy.pyrenet.fr
обсуждение исходный текст
Ответы Re: vacuums and ctid  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Devrim GUNDUZ
Дата:
Сообщение: Re: psql's \l
Следующее
От: Fabien COELHO
Дата:
Сообщение: tablespace and sequences?